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.

N457CMIasco Flight Training Inc · Redding, CABuilt 2000 · S/N 17280849 N457EPRainier Flight Service LLC · Renton, WABuilt 2015 · S/N 172S11593 N457SKWorld Marketing Syndicate I · Wilmington, DEBuilt 1975 · S/N 17264736 N457SPSouth Dakota State University · Brookings, SDBuilt 1999 · S/N 172S8321 N458CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 172S13267 N458CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280850 N458SPChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8323 N4593VFranklin Eric J · Anchorage, AKBuilt 1980 · S/N 172RG0330 N459CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 172S13270 N459CMIasco Flight Training Inc · Redding, CABuilt 2000 · S/N 17280851 N459CSHorizon Flight Center LLC · Chesapeake, VABuilt 2017 · S/N 172S12013 N459EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12649 N459JCBruton Bert L · San Angelo, TXBuilt 2012 · S/N 172S11162 N459SPAmeriflyers Of Texas Inc · Addison, TXBuilt 1999 · S/N 172S8325 N45AGHogan Thomas A · Fairfield, OHS/N 17275652 N45DARegistration Pending · Fairbanks, AKRegistration pendingBuilt 1969 · S/N 17258210 N45EFSvetfur Aviation LLC · Camden, SCBuilt 2001 · S/N 172S8982 N45UDAlf Ix LLC · Chicago, ILBuilt 2017 · S/N 172S12073 N46001Df Kitcar LLC · Red Oak, TXBuilt 1968 · S/N 17256980 N46003Carroll Michael L · Rochester, WABuilt 1968 · S/N 17256981 N4600JDavis Robert M · Dallas, NCBuilt 1979 · S/N 17273652 N4600LRitchie Edwin J · Katonah, NYS/N 17254595 N46011Jackson William T · Clinton, OHBuilt 1968 · S/N 17256986 N46015Leaders Flying Service LLC · Clear Lake, MNS/N 17256988 N46019La Porte Aero Club Inc · La Porte, INS/N 17256992 N4601GResicum International LLC · Gulf Shores, ALBuilt 1979 · S/N 17273270 N4601RMiddle Tennessee State University · Murfreesboro, TNS/N 172RG0003 N4601VDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1980 · S/N 172RG0336 N46024Garfield Joshua E · Tampa, FLBuilt 1968 · S/N 17256995 N46027Cleary Thomas J · Fairport, NYBuilt 1968 · S/N 17256997 N46028First Take Aviation LLC · Van Nuys, CABuilt 1968 · S/N 17256998 N46030Constance Air LLC · Luthersville, GABuilt 1968 · S/N 17257000 N46031Soucy Gary J · Brewer, MEBuilt 1968 · S/N 17257001 N46047Loudermilk John A · Nashville, TNBuilt 1968 · S/N 17257010 N4604VRogers Ann M · Traverse City, MIS/N 172RG0337 N46054Cabirdassou Meena · Arcadia, CABuilt 1968 · S/N 17257015 N46057Flight Time Builders Inc · Memphis, TNBuilt 1968 · S/N 17257018 N46060Registration Pending · Factoryville, PARegistration pendingBuilt 1968 · S/N 17257019 N46072Fly Anytime LLC · Kankakee, ILBuilt 1968 · S/N 17257025 N46078Parrish Aviation Flight Academy LLC · Southlake, TXBuilt 1968 · S/N 17257030 N46085Davenport Jimmy J · Hayesville, NCBuilt 1974 · S/N 17264175 N46087Range Steven V · Greenfield, ILBuilt 1968 · S/N 17257034 N46091Pilot Instructional Center LLC · Kansas City, MOBuilt 1974 · S/N 17264176 N46092Breithaupt Tracy L · Alexandria, LAS/N 17257038 N4609QN4609q LLC · Opa-Locka, FLBuilt 1973 · S/N 17261724 N460EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12650 N460GPage Robert · Santaquin, UTBuilt 1964 · S/N 17251567 N46100Aerflow Inc · Jersey City, NJBuilt 1968 · S/N 17257041 N46101Patel Aman · Wesley Chapel, FLBuilt 1968 · S/N 17257042 N46107Trieber Steven M · Eastport, MEBuilt 1968 · S/N 17257046

Back to AD 90-06-03 R1