Skip to content

Registered aircraft · 20,687

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N955JAAero Equities LLC · Ventura, CABuilt 2007 · S/N 172S10501 N955LCSewell Michael D DBA · Russellville, ALBuilt 1974 · S/N 17264572 N955PTCappe Investment Group LLC · Homestead, FLBuilt 1974 · S/N 17264573 N955RSDuck Troy · Kannapolis, NCS/N 17250144 N955SPBarto Jerrel C · Kula, HIBuilt 1999 · S/N 172S8155 N9560SMoore Justin W · Hollywood Park, TXBuilt 1998 · S/N 17280495 N9560VRegistration Pending · Big Spring, TXRegistration pendingBuilt 1974 · S/N 17264362 N9560WGeneral Aviation LLC · Henderson, NVBuilt 1998 · S/N 17280496 N9561VAbove And Beyond Aviation LLC · Austin, TXBuilt 1998 · S/N 17280497 N9562BCharleston Flying Club LLC · Charleston, SCBuilt 1981 · S/N 172RG0882 N9562HL & W Aircraft Investments LLC · Homestead, FLBuilt 1975 · S/N 17266230 N9562PAvolant Aviation LLC · Mooresville, NCBuilt 1999 · S/N 17280499 N9562QSilverhawk Aviation Academy Oregon LLC · Ontario, ORBuilt 1998 · S/N 17280501 N9562VWinged Winds LLC · Douglassville, PABuilt 1974 · S/N 17264364 N9563AChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280502 N9564HLafleur Laurence J · Natick, MABuilt 1975 · S/N 17266232 N9566BQualitair LLC · MichelstadtBuilt 1981 · S/N 172RG0885 N9566HGarcia Mario · Yuma, AZBuilt 1975 · S/N 17266233 N9566LNorth Sound Aviation · Sedro Woolley, WABuilt 1986 · S/N 17276578 N9566VS D Enterprises Ltd · Brookhaven, NYBuilt 1974 · S/N 17264368 N9567HCurley Mark L · Alamosa, COBuilt 1975 · S/N 17266234 N9567VBdc Aero LLC · Miami, TXRegistration expired, pending cancellationBuilt 1974 · S/N 17264369 N9568GTakai Hiroyasu · San Jose, CABuilt 1979 · S/N 17273631 N9568LD & S Aviation LLC · Spring, TXBuilt 1986 · S/N 17276580 N9568VAnderson Zachery D · Bigfork, MTBuilt 1974 · S/N 17264370 N9569HOsborn Larry R · Summerville, SCBuilt 1975 · S/N 17266235 N956SPN3812q LLC · San Diego, CABuilt 1999 · S/N 172S8156 N9571HWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17266236 N9571VTempleton John E · Loami, ILBuilt 1974 · S/N 17264373 N9572HGeneral Aviation LLC · Henderson, NVBuilt 1975 · S/N 17266237 N9572LJav Air Services LLC · Anchorage, AKBuilt 1986 · S/N 17276582 N9572VHill Timothy E · Hooks, TXBuilt 1974 · S/N 17264374 N9572WDr Equipment LLC · Ackerly, TXBuilt 1998 · S/N 17280544 N9573BDocarmo Aviation LLC · Dallas, TXBuilt 1981 · S/N 172RG0890 N9573VReynolds Darryl G · Wills Point, TXBuilt 1974 · S/N 17264375 N9574BHinds Community College · Bolton, MSBuilt 1981 · S/N 172RG0891 N9574HJb III LLC · Stuart, FLBuilt 1975 · S/N 17266238 N9575VFurnari Alfio · Hutchinson Island, FLBuilt 1974 · S/N 17264377 N9577BRegistration Pending · Scottsdale, AZRegistration pendingBuilt 1981 · S/N 172RG0894 N9577VMdr Flying Inc Trustee · Wilmington, DEBuilt 1974 · S/N 17264379 N9577WIasco Flight Training Inc · Redding, CABuilt 1998 · S/N 17280527 N9577ZAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280528 N9578BHalseth Harald E · El Paso, TXBuilt 1981 · S/N 172RG0895 N9579VPlaisted Aviation LLC · Elk River, MNBuilt 1998 · S/N 17280529 N957DDDon Davis Aviation Inc · Henderson, KYBuilt 2021 · S/N 172S12775 N957EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2023 · S/N 172S13001 N957ESVolar I LLC · Edmond, OKBuilt 2008 · S/N 172S10675 N9581GN9581g Corp · Skokie, ILBuilt 1998 · S/N 17280530 N9582HMiller Timothy · Saratoga, CABuilt 1975 · S/N 17266244 N9582VCady Craig D · New Braunfels, TXBuilt 1974 · S/N 17264384

Back to AD 90-06-03 R1