Registered aircraft · 108,433

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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.

N2532ZWest Charles A · Independence, ORBuilt 1962 · S/N 185-0532 N2533QBusse Alana · Thousand Oaks, CABuilt 1966 · S/N 18257733 N2533RAdams Michael B · Scottsdale, AZBuilt 1967 · S/N 18258233 N2533TMende Jeffrey · Crystal Lake, ILBuilt 1969 · S/N NAV-4-2533 N2533WH&A Aircraft Services LLC · Omaha, ARBuilt 1973 · S/N MC-208 N2534BMckane Holdings LLC · West Point, MSBuilt 2003 · S/N 004 N2534PPearson Vincent N · Broken Bow, NES/N 22-2897 N2534RRobuck Dale J · Knoxville, IABuilt 1967 · S/N 18258234 N2534WFreds Legacy LLC · Chagrin Falls, OHBuilt 1974 · S/N MC-214 N2535ESale Reported · Griffin, GASale reportedBuilt 1989 · S/N 876 N2535FBryan Michael R · Brownfield, TXBuilt 1965 · S/N 7GCAA-33 N2535QDerodeff Stephan A · Nipomo, CABuilt 1966 · S/N 18257735 N2535UMyer Mark A · Sandusky, OHBuilt 1979 · S/N 28-8090054 N2536EEarle James K · Argonia, KSBuilt 1959 · S/N 22-6816 N2536GDittmer Larry J · Basco, ILBuilt 1959 · S/N 51836 N2536QWiebe Tim · Newton, KSBuilt 1966 · S/N 18257736 N2536XLouscher Steven Trustee · Paullina, IABuilt 1964 · S/N P206-0036 N2537GDirigo Aviation LLC · York, MEBuilt 1959 · S/N 51837 N2537KPanuski Christopher Louis · Davidson, NCBuilt 1978 · S/N 18052978 N2537TBusiness Air Ventures LLC · Georgetown, DEBuilt 1970 · S/N NAV-4-2537 N25386Fairview Farms Inc · Poteau, OKBuilt 1985 · S/N 28-8590088 N2538R1 Point 21 Gigawatts LLC · Auburn, WABuilt 1967 · S/N 18258238 N2538SBarbo Walter A · Aurora, COBuilt 1976 · S/N 21061322 N2538THeeren Craig J · Williston, TNBuilt 1970 · S/N NAV-4-2538 N2538WBeach Eric J · Middletown, NYBuilt 1974 · S/N MC-215 N2538ZSnell Marion Lea · Ackerly, TXBuilt 1977 · S/N 342-77 N2539ENimbus 2005 LLC · Glenview, ILBuilt 2005 · S/N 42078 N2539GTpt Aviation LLC · Caseville, MIBuilt 1979 · S/N 38-79A0550 N2539RWillard John E Jr · Rockwood, MEBuilt 1967 · S/N 18258239 N2539TSouthwest Aircraft LLC · Fairacres, NMBuilt 1970 · S/N NAV-4-2539 N2539WZavala David · Demorest, GABuilt 1974 · S/N MC-219 N253AMiller Christopher T · Newnan, GABuilt 1956 · S/N 23-806 N253ATAirlines Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496057 N253BLewis Donald L · Brant Lake, NYBuilt 1957 · S/N 13 N253CAJtv Enterprises LLC · Painesville, OHBuilt 1977 · S/N 339-77 N253CCL-Bird LLC · Hood River, ORBuilt 2012 · S/N CC18-0055 N253CDAngell John C · Ann Arbor, MIBuilt 2003 · S/N 0448 N253DCD & M Aviation Inc · Amelia, OHS/N 2053 N253DFFort Greg R · Burien, WABuilt 1976 · S/N 18052686 N253EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13310 N253ERFreeman Joshua A · Platteville, COBuilt 1978 · S/N R18200723 N253JAYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 28020034 N253JC96 Quick LLC · Wilmington, DEBuilt 1963 · S/N CD-673 N253KTInternational Air Services Inc Trustee · Carson City, NVBuilt 1984 · S/N E2200 N253LPLazo Aitor · Irving, TXBuilt 2023 · S/N 92286 N253MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881445 N253NShay Aviation LLC · Aurora, COBuilt 2020 · S/N 41999 N253PRRenaud Paul D · Tenafly, NJBuilt 2012 · S/N 40686 N253RAReynolds Darryl G · Wills Point, TXBuilt 1981 · S/N 17274790 N253RLArs Automation Design Inc · Greensboro, NCBuilt 1980 · S/N EA-131

Back to AD 2007-04-19 R1