Registered aircraft · 20,678

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.

N1158VAtp Aircraft 7 LLC · Wilmington, DEBuilt 2006 · S/N 172S10355 N1159FRodimel Troy R · Greenwood, INS/N 17254754 N1159KCavu Aero LLC · Marietta, GABuilt 2006 · S/N 172S10357 N1159ZThunderfighter LLC · Englewood, COBuilt 2006 · S/N 172S10362 N115CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12330 N115FJFargo Jet Center LLC · Fargo, NDBuilt 2008 · S/N 172S10784 N115KSKent State University · Stow, OHBuilt 1999 · S/N 17280819 N115LWCrest Airpark Inc · Kent, WABuilt 2005 · S/N 172S9868 N115MBChalet Suzanne Aviation Inc · Lake Wales, FLS/N 17248936 N115SV115sv LLC · Lamar, MOBuilt 2004 · S/N 172S9663 N115TAAtp Aircraft 7 LLC · Wilmington, DEBuilt 2018 · S/N 172S12145 N1160FOcala Aviation Services Inc · Ocala, FLS/N 17254755 N11614Lewis University · Romeoville, ILBuilt 2006 · S/N 172S10360 N1161FBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 17254756 N1163FMid-Tenn Aero Club Inc · Franklin, TNBuilt 1979 · S/N 17272962 N1165UWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17266872 N1166FMortensen Alex · Burley, IDBuilt 1966 · S/N 17254761 N1166WFlight Operations Aircraft LLC · Wilmington, DEBuilt 2006 · S/N 172S10363 N1167FRegistration Pending · Cotter, ARRegistration pendingBuilt 1966 · S/N 17254762 N11682Jahawk Leasing LLC · Sugar Grove, ILBuilt 2006 · S/N 172S10365 N1168FAnderson Jeffrey A · Runaway Bay, TXBuilt 1966 · S/N 17254763 N1169FJensen Richard · Cayucos, CABuilt 1966 · S/N 17254764 N116CRConti Christine M · Plantation, FLBuilt 1976 · S/N 17266985 N116FPRandall David J · Balsam Lake, WIBuilt 1978 · S/N 17271241 N116JEAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12167 N116KSKent State University · Stow, OHBuilt 1999 · S/N 17280820 N116WETextron Aviation Inc · Wichita, KSS/N 172S13611 N1170FHowerton Kurt · Groveland, CABuilt 1966 · S/N 17254765 N1170MBryson William H III · Cook, MNBuilt 1969 · S/N 17258670 N1171BWarganich Daniel J · Placerville, CABuilt 1960 · S/N 47675 N1171FBlohm Paul J. · Tiffin, OHS/N 17254766 N1172FLincoln Meagan C · Kotzebue, AKBuilt 1966 · S/N 17254767 N1172GSkranak James Robert · St Maries, IDBuilt 1966 · S/N 17254094 N1172MTodd Kevin E · Bismarck, NDBuilt 1969 · S/N 17258672 N1173FTrue Course LLC · West Monroe, NYBuilt 1966 · S/N 17254768 N1173MFlathead Lake Aviation LLC · Polson, MTBuilt 1969 · S/N 17258673 N1173XWnc Aviation LLC · Arden, NCBuilt 2006 · S/N 172S10379 N1174MWhitted Danny E · Candler, NCBuilt 1969 · S/N 17258674 N1176UPlane Leasing LLC · Wilmington, DEBuilt 1976 · S/N 17266877 N1177FSeaman Kenny James · Edgewood, TXBuilt 1966 · S/N 17254772 N1178FTrue Course LLC · West Monroe, NYBuilt 1966 · S/N 17254773 N1178MLehman David G · Kent, WABuilt 1969 · S/N 17258678 N1179MBartholomew Thomas C · Stanwood, WABuilt 1969 · S/N 17258679 N1179UBadgerland Aero Club Inc · Fitchburg, WIBuilt 1976 · S/N 17266880 N117ABHellickson Brad · Corona, CAS/N 17271253 N117JBGenerations Flying Club LLC · Washington, MOBuilt 1978 · S/N 17270644 N117KSKent State University · Stow, OHBuilt 1999 · S/N 17280821 N117PBLadue Scott B · Fate, TXBuilt 1981 · S/N 172RG0897 N117RCMaresh Jeremiah · Redding, CAS/N 172RG0034 N117SVFlight Operations Aircraft LLC · Wilmington, DEBuilt 2005 · S/N 172S10073

Back to AD 90-06-03 R1