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.

N738DXPlanes Over Plains LLC · Benton, KSBuilt 1977 · S/N 17269906 N738DYRnb Aviation LLC · Montgomery, TXBuilt 1977 · S/N 17269907 N738EAMatt Plane One LLC · Gilbert, AZBuilt 1977 · S/N 17269909 N738EGJeff Air Pilot Services LLC · Shelbyville, INBuilt 1977 · S/N 17269915 N738EHHills Holding · Newark, DEBuilt 1977 · S/N 17269916 N738ENKohlhaas Jerome R · Hardy, IABuilt 1977 · S/N 17269921 N738EPCommand-Aire LLC · Seattle, WABuilt 1977 · S/N 17269922 N738EUGehrke Charles A · Aneta, NDBuilt 1977 · S/N 17269927 N738EWWasowski Walter J · Riverside, CABuilt 1977 · S/N 17269929 N738EYPettyjohn Nancy Paulette Sautebien · Dearborn, MIBuilt 1977 · S/N 17269931 N738FAFly Maui LLC · Puunene, HIBuilt 1977 · S/N 17269933 N738FCMontepiedra John Glenn R · Rch Palos Vrd, CAS/N 17269935 N738FDAero Maintenance Inc · Vancouver, WABuilt 1977 · S/N 17269936 N738FFTed Kingston Inc · Strathmere, NJBuilt 1977 · S/N 17269938 N738FMFinefield James P · Cary, ILBuilt 1977 · S/N 17269943 N738FYVero Technical Support Inc · Pensacola, FLBuilt 1977 · S/N 17269954 N738FZSun Aviation Inc · Cambridge, MNBuilt 1977 · S/N 17269955 N738GACone Ira M · Frazier Park, CABuilt 1977 · S/N 17269956 N738GBFlying Grass Hopper LLC · Barrington, ILBuilt 1977 · S/N 17269957 N738GEPs Aviation Inc · Granada, MNBuilt 1977 · S/N 17269960 N738GJJlinn Aviation Inc · Quinlan, TXBuilt 1977 · S/N 17269964 N738GMNesher Aviation II LLC · Jacksonville, FLBuilt 1977 · S/N 17269966 N738GSWestern Edge Aviation LLC · Dickinson, NDBuilt 1977 · S/N 17269971 N738GVMolnar Raymond Jr · Ashford, CTBuilt 1977 · S/N 17269974 N738GWJensen Rodney H · Sandy, UTS/N 17269975 N738GZPickard Steve H DBA · Louisville, GABuilt 1977 · S/N 17269978 N738HATerrill Mary C · Bloomingdale, ILBuilt 1977 · S/N 17269979 N738HDG&M Aircraft Inc · Wheat Ridge, COBuilt 1977 · S/N 17269982 N738HHPitre David E · Santa Fe, TXBuilt 1977 · S/N 17269986 N738HJMcnamara Patrick J · Marstons Mills, MABuilt 1977 · S/N 17269987 N738HKEini Yaakov · Valley Glen, CABuilt 1977 · S/N 17269988 N738HPNidiffer Alan W · Brookings, ORBuilt 1977 · S/N 17269992 N738HSFlycarolina LLC · Concord, NCBuilt 1977 · S/N 17269995 N738HTRucci Daniel C · Saint Cloud, FLBuilt 1977 · S/N 17269996 N738HXRick Aviation Inc · Newport News, VABuilt 1977 · S/N 17270000 N738JDClover Management Systems Inc · Sanford, FLBuilt 1977 · S/N 17270006 N738JFCopperhead Environmental Consulting Inc · Paint Lick, KYBuilt 1977 · S/N 17270008 N738JGSullivan James F · Hamilton, ILBuilt 1977 · S/N 17270009 N738JJGreat Lakes Aviation Inc · Batavia, NYBuilt 1977 · S/N 17270011 N738JPHaskins Robert A · Salinas, CABuilt 1977 · S/N 17270016 N738JSWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 17270019 N738JTNorthwoods Air LLC · Orono, MEBuilt 1977 · S/N 17270020 N738JULlano Masonry LLC · Lubbock, TXBuilt 1977 · S/N 17270021 N738JWAllen Stephen R · Ventura, CABuilt 1977 · S/N 17270023 N738JXSuperior Flying Services LLC · Superior, WIBuilt 1977 · S/N 17270024 N738KAFlying Aces Aero Fleet Inc · Guyton, GABuilt 1977 · S/N 17270027 N738KCCarter Flygare Inc · Sacramento, CABuilt 1977 · S/N 17270029 N738KFShouling & Philip Enterprise · Lancaster, CABuilt 1977 · S/N 17270032 N738KG738 Kilo Golf LLC · Southern Shores, NCBuilt 1977 · S/N 17270033 N738KJFly Compton Aeronautical Education Foundation · Compton, CAS/N 17270035

Back to AD 90-06-03 R1