Skip to content

Registered aircraft · 20,683

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.

N5449HMoorhead Aviation Services LLC · Moorhead, MNBuilt 1975 · S/N 17265445 N5449RMartin David · Waterport, NYBuilt 1965 · S/N 17253002 N544EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2025 · S/N 172S13318 N544KSKent State University · Stow, OHBuilt 2026 · S/N 172S13510 N544SPSilverhawk Aviation Academy LLC · Caldwell, IDS/N 172S8399 N54502Ho Simpson S · Poway, CABuilt 1981 · S/N 17274991 N5450HLima-001 LLC · Muscatine, IABuilt 1975 · S/N 17265446 N5450RMayer Ag Service · Chamberlain, SDBuilt 1965 · S/N 17253003 N5451KSkywarior Flight Training Inc · Pensacola, FLBuilt 1980 · S/N 17274117 N5451RYoungstown Warren Development Partners · Vienna, OHBuilt 1965 · S/N 17253005 N5452KAviation Club LLC · Sussex, NJBuilt 1980 · S/N 17274118 N5452RWilliams Matthew W · Auburn, WABuilt 1965 · S/N 17253006 N5452TEagle Sky Patrol Inc · Deadwood, SDBuilt 1964 · S/N 17251352 N54531Jordan Alex N · Clarkton, NCBuilt 1981 · S/N 17274995 N5453KDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N 17274119 N5453RVaughn Mark R · Fort Payne, ALBuilt 1965 · S/N 17253007 N5454KGolden Mahalo LLC · Sheridan, WYBuilt 1980 · S/N 17274120 N5454TPearce David W Trustee · Anchorage, AKBuilt 1964 · S/N 17251354 N5455HMiller Michael R · Portage, MIBuilt 1975 · S/N 17265449 N5455JFriend John M · Ozawkie, KSBuilt 1980 · S/N 17273801 N5455REpstein Paul · Pensacola, FLBuilt 1965 · S/N 17253010 N5455TStrickland Justin Ryan · Lovington, NMBuilt 1964 · S/N 17251355 N54569Buehler Thomas M · Renton, WABuilt 1981 · S/N 17275002 N5456TKelley Keith B · Forney, TXBuilt 1964 · S/N 17251356 N54576Rick Aviation Inc · Newport News, VAS/N 17275003 N5457DSanders Flight Training Center Inc · Jasper, ALS/N 17272574 N5457ETravis Gregory R · Bloomington, INFirst renewal noticeBuilt 1978 · S/N 17271873 N5457JRegistration Pending · Chino, CARegistration pendingBuilt 1980 · S/N 17273803 N5457RFarrand David V · London, OHBuilt 1965 · S/N 17253013 N54589Twin City Cloud 7 Inc · Eden Prairie, MNBuilt 1981 · S/N 17275007 N5458RLafranchise Louis C · Aurora, ORS/N 17253014 N5458TTodd Tyler L · Quitman, MSBuilt 1964 · S/N 17251358 N5459HWard John W · Troutdale, ORBuilt 1975 · S/N 17265452 N5459KPropability One LLC · Daytona Beach, FLBuilt 1980 · S/N 17274125 N5459RAllsup Rachel B · Anchorage, AKBuilt 1965 · S/N 17253015 N5459TBrennan Brian L · Tipton, IABuilt 1964 · S/N 17251359 N545DSAero Maintenance Inc · Vancouver, WABuilt 1980 · S/N 17273867 N545FCatching Freedom LLC · Bozeman, MTS/N 172S12357 N545KSKent State University · Stow, OHBuilt 2026 · S/N 172S13512 N545NDChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10857 N545QCatching Freedom LLC · Bozeman, MTS/N 172S12371 N545UCatching Freedom LLC · Bozeman, MTS/N 172S12311 N545YCatching Freedom LLC · Bozeman, MTS/N 172S12327 N545ZDornoch Services LLC · Dover, DEBuilt 2008 · S/N 172S10770 N5460RTake Angels Aviation LLC · Watertown, NYBuilt 1965 · S/N 17253017 N5461KFaragallah Allan A · Garden Grove, CABuilt 1980 · S/N 17274127 N54628Ohio State University · Columbus, OHBuilt 1981 · S/N 17275013 N5462QLeading Edge Flight Academy LLC · Bend, ORBuilt 1973 · S/N 17261792 N5462RJameson Fred · Rathdrum, IDS/N 17253019 N54633Warner Walter M · Willow, AKBuilt 1981 · S/N 17275016

Back to AD 90-06-03 R1