Registered aircraft · 47,133

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:2000-23-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21') 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:2000-23-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
  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:2000-23-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
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.

N479WWBig Booty Air LLC · Bentonville, ARBuilt 2026 · S/N 11221 N47AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1972 · S/N 340-0114 N47ALSrs Aviation LLC · Gadsden, ALBuilt 2024 · S/N 10083 N47AM2 Point Aviation LLC · Colorado Springs, COBuilt 2000 · S/N 1054 N47APAfrican Parks Aviation Inc Trustee · Cheyenne, WYBuilt 1983 · S/N U20606768 N47BCBrentech Leasing LLC · Cartersville, GABuilt 1988 · S/N 4608129 N47BEWestgard Richard W · Golden, COBuilt 1984 · S/N 25-0800 N47BGVonweisenstein Thomas W · Brentwood, TNBuilt 1974 · S/N 310Q1061 N47CPHibler Philip Earl · Alameda, CABuilt 1957 · S/N 32304 N47DBCala Brush Supply Inc · Weslaco, TXBuilt 1978 · S/N P21000175 N47DSHalls Dave · Lilburn, GABuilt 1959 · S/N 39005 N47FAAshe Olen Reid Jr Trustee · Winston Salem, NCBuilt 2004 · S/N 0965 N47GEMcbride Michael J · Loxley, ALBuilt 1978 · S/N 18266717 N47GTGt Airways LLC · Orlando, FLBuilt 2025 · S/N 10893 N47HBSparks John Jr · Orange Beach, ALBuilt 1961 · S/N CD-392 N47JBBean Jackson A · Quinlan, TXBuilt 1998 · S/N E3207 N47JTM & M Investments Of Jonesboro LLC · Jonesboro, ARBuilt 1973 · S/N D-9432 N47KABroom John F · Sherman, TXBuilt 1974 · S/N E-530 N47KKHermansen Dane K · Ormond Beach, FLBuilt 1983 · S/N T30300216 N47KPInternational Air Services Inc Trustee · Carson City, NVBuilt 1998 · S/N 25-2023 N47KSReiland Daniel E · Spring Valley, MNBuilt 1967 · S/N 18258363 N47LGStephens Jack T III · Nashville, TNS/N 1316 N47LLSmith Roy H · Garberville, CABuilt 1947 · S/N D-972 N47MACirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11617 N47MDBrambles Inc · Bakersfield, CABuilt 1977 · S/N 414-0945 N47MRFree Bird Aviation LLC · Wasilla, AKFirst renewal noticeS/N 41057 N47NFAndrews University · Berrien Springs, MIS/N 60-6047 N47PHReal Time Aviation LLC · Southlake, TXBuilt 2016 · S/N TH-2467 N47PSPalm Springs Air Museum Inc · Palm Springs, CABuilt 1973 · S/N 18262767 N47RJBzm LLC · Incline Village, NVS/N 25-0525 N47RTBas Part Sales LLC · Greeley, COBuilt 1997 · S/N E-3142 N47RWSale Reported · Glen Allen, VASale reportedS/N 35088 N47SAValiair Lc Trustee · Casper, WYBuilt 2024 · S/N 9759 N47SLLong James A · Penn Valley, CABuilt 2005 · S/N LIV-392 N47SPDurham Rex L · Blakely, GABuilt 1969 · S/N 310P0176 N47SRRendezvous T82 LLC · Mansfield, TXS/N 1418 N47TCWright Frank David · Sequin, TXBuilt 1975 · S/N 21061028 N47TGTan Industries LLC · Wilmington, DEBuilt 1980 · S/N TC-2343 N47TLObendorf Phillip G · Parma, IDBuilt 1976 · S/N 18503185 N47TPMccreery Aviation Co Inc · Mcallen, TXBuilt 2010 · S/N 2037 N47TZZilka Timothy R · Alpine, WYBuilt 1977 · S/N 18265448 N47WK57 Bw LLC · Reno, NVBuilt 2007 · S/N TH-2179 N47WTDoucet Lucius J III · Baton Rouge, LABuilt 1966 · S/N D-8217 N47WWLake Shore Aircraft Holdings LLC · Wurtsboro, NYBuilt 2011 · S/N E-3963 N47WZPengilly Sky LLC · Ellicottville, NYBuilt 1975 · S/N 18263911 N47XTRivard Beauregard E · Shafer, MNBuilt 2024 · S/N 001 N4800B310 LLC · Auburn, WABuilt 1955 · S/N 35100 N4800HBellings Jerry A · Neshkoro, WIBuilt 1972 · S/N 18261310 N4800QVan Bortel Inc · Victor, NYBuilt 1978 · S/N 18503562 N4800UWest Michigan Flying Club Inc · Norton Shores, MIBuilt 1963 · S/N 205-0500

Back to AD 2000-23-21