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.

N448AFBeale Air Force Base Aero Club · Beale Afb, CABuilt 1998 · S/N 17280448 N448CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12505 N448ERAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280610 N44919Irvin Thomas D · Ripley, TNBuilt 1959 · S/N 46634 N4493RBarnstormers Inc · Bemidji, MNBuilt 1974 · S/N 17263235 N4494LJ&S Aviation Services LLC · Hastings, NEBuilt 1966 · S/N 17254589 N4495LBlue Wings LLC · Brecksville, OHS/N 17254590 N4495RKohl James D Trustee · Deerfield, ILBuilt 1974 · S/N 17263237 N4496LHotel Charlie LLC · Lewes, DES/N 17254591 N4497RMazurek Drew A · New Haven, CTBuilt 1974 · S/N 17263239 N4499LKilo Charlie LLC · Lenexa, KSBuilt 1966 · S/N 17254594 N449CSHorizon Flight Center LLC · Chesapeake, VABuilt 2017 · S/N 172S12025 N449SPGolden Eagle Flying Club Ltd · West Islip, NYBuilt 1999 · S/N 172S8315 N44BLBoehr Greg J · Mc Cool Junction, NES/N 17256854 N44CUAirstar Aviation LLC · Manawa, WIBuilt 1976 · S/N 17268037 N44DMGorge Winds Aviation Inc · Fairview, ORBuilt 1973 · S/N 17261488 N44KPHargrave Margarite D · Seattle, WABuilt 1978 · S/N 172-70904 N44LKCessna Skyhawk LLC · Parker, COFirst renewal noticeBuilt 1979 · S/N 17273400 N44PForester Dwain E · Tonopah, NVBuilt 1961 · S/N 17248620 N44PYSegler Angela U · Marco Island, FLBuilt 2000 · S/N 172S8543 N44RCPeterson Matthew W · Ethel, LABuilt 1957 · S/N 29593 N44RPCook Aviation Services LLC · Fargo, NDS/N 17250833 N44STTakvorian Sevag · West New York, NJBuilt 1979 · S/N 17271609 N44UDB & K Aviation LLC · Danville, CABuilt 2017 · S/N 172S12072 N4501EOptima Aviation LLC DBA · Lewisville, TXS/N 17271614 N450EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S12955 N4511EN2893e LLC · Reno, NVBuilt 1978 · S/N 17271619 N452EPRainier Flight Service LLC · Renton, WABuilt 2015 · S/N 172S11586 N452SMChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 172S10528 N4530EAig Aeronautics LLC · San Juan, PRBuilt 1978 · S/N 17271621 N4534E34 Echo Group · Spring Branch, TXBuilt 1978 · S/N 17271622 N4538EGrasshopper Flying Club Inc · Poughkeepsie, NYBuilt 1978 · S/N 17271623 N453CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280845 N453EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12645 N453PTHenrie Aviation LLC · Fairfield, NJBuilt 1984 · S/N 17276262 N453SPUnited States Air Force Owner · Elmendorf Afb, AKBuilt 1999 · S/N 172S8297 N4547EG&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 17271626 N454AGAb Prop Plane II LLC · Metairie, LABuilt 2015 · S/N 172S11588 N454BMCorman David L · Lovington, ILBuilt 1972 · S/N 17260799 N454CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280846 N4550EPommy & Swede LLC · Valentine, NEBuilt 1978 · S/N 17271628 N455EPDove Aviation 455ep LLC · Stuart, FLBuilt 1998 · S/N 17280664 N456CBCollins Bruce H · Caldwell, TXBuilt 1968 · S/N 17257257 N456DXAviolease LLC · Vancouver, WABuilt 2005 · S/N 172S9871 N456ERSoaring 2 Success LLC · Cary, ILBuilt 1998 · S/N 17280667 N456MBDhs Operations LLC · Wilmington, DEBuilt 1997 · S/N 17280033 N456SPAc Aviation LLC · Ocklawaha, FLBuilt 1999 · S/N 172S8320 N4574VSmtm Holdings Inc · Wilmington, DES/N 17266358 N4577Gateway Of Sturgis LLC · Sturgis, MIBuilt 1999 · S/N 172S8285 N457BCMorris Thomas Z Trustee · Spokane Valley, WABuilt 1974 · S/N 17264589

Back to AD 90-06-03 R1