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.

N4458ARaimondi Johann I · Doral, FLBuilt 1970 · S/N D-9145 N4458SCn Aviation LLC · Mesa, AZBuilt 1976 · S/N TJ-58 N4458XBabichix Inc · Hiram, GAS/N 34-7670049 N4459SJameson Kelly J · Chappell Hill, TXBuilt 1975 · S/N E-692 N445CDMockingbird Wings LLC · Wilmington, DEBuilt 2007 · S/N 2504 N445DCWith Wings As Eagles Aviation LLC · Middletown, DEBuilt 1975 · S/N 18263690 N445HPChopra Family Lp · Tulare, CABuilt 1985 · S/N EA-445 N445MLCirrus Sr22t 8876 Inc Trustee · Wilmington, DEBuilt 2022 · S/N 8876 N445PWelsh Steven M · Oxford, NCBuilt 2001 · S/N E-3415 N445YSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1951 · S/N 22817 N4460S300 Dollar Burger LLC · Elmhurst, ILBuilt 1975 · S/N E-691 N4461WKimball Douglas S · Bedford, INBuilt 1974 · S/N TC-1677 N4462BRussell Industries Inc · Millcreek, UTS/N 336-0159 N4462SMaxxum Financial Group Inc · Destrehan, LABuilt 1975 · S/N TC-1876 N4463SJ&J Aviation LLC · Hendersonville, TNBuilt 1975 · S/N CE-580 N4464QTofteland Chad E · Westhope, NDS/N 18800864 N4464WMantei & Associates Ltd · Lexington, SCBuilt 1974 · S/N E-543 N4465SFtp LLC · Newington, CTBuilt 1975 · S/N E-693 N4466LSmyrna Aviation LLC · Edgewater, FLBuilt 2000 · S/N E-3366 N4466QSchindler Kelly J DBA · Billings, MTBuilt 1972 · S/N 18800866 N4466SRegistration Pending · West Monroe, LARegistration pendingS/N D-9779 N4466WPeregrine Howard Fund V Owner LLC · New Orleans, LABuilt 1973 · S/N TE-936 N4467AWynn Andrew J · Montgomery, ALBuilt 1970 · S/N E-212 N4467SK & M Leasing Inc · Camden, ARBuilt 1975 · S/N E-694 N4468FIdahi Aviation LLC · Eagle, IDBuilt 2004 · S/N 41043 N4468SKyle Robert K · Madison, MSBuilt 1975 · S/N E-696 N4468WBorth John D · Meade, KSBuilt 1974 · S/N D-9604 N4469WDietle Kurt D · Valley Springs, CABuilt 1974 · S/N CE-494 N446ALValiair Lc Trustee · Casper, WYS/N CE-1137 N446BDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 2366 N446CDMichiana Air Activities Inc · Osceola, INBuilt 2004 · S/N 1446 N446CPOn Eagles Wings Aviation LLC · Ponte Vedra Beach, FLBuilt 2008 · S/N 3297 N446DMRegistration Pending · Austin, TXRegistration pendingBuilt 2019 · S/N 2036 N446DWAnnes Wings LLC · Boulder, COBuilt 1978 · S/N 34-7870051 N446FMProspect Aviation LLC · Puyallup, WABuilt 2017 · S/N 1643 N446HBAerozap Ventures LLC · Sartell, MNBuilt 2021 · S/N 2379 N446HDSpace Change You LLC · Destin, FLBuilt 2017 · S/N 1626 N446HKHotel Kilo LLC · Forest, VABuilt 2014 · S/N 0898 N446JRSpangler John T · Mount Pleasant, PABuilt 1974 · S/N CE-541 N446MMInternational Air Services Inc Trustee · Carson City, NVS/N 4608006 N446MTValiair Lc Trustee · Casper, WYBuilt 2025 · S/N 10708 N446PMorris Danny J · Upland, CABuilt 1993 · S/N E-2835 N446PCStatius-Muller Robert C Trustee · Stamford, CTBuilt 2006 · S/N 29-0446 N446RDwons Roland Joseph · Oro Valley, AZS/N D-8474 N446SKFlying Montana LLC · Bozeman, MTBuilt 2006 · S/N 41714 N446SNWarren Dennis · Las Vegas, NVBuilt 1966 · S/N 337-0454 N446TThatcher James W · La Canada Flt, CABuilt 1970 · S/N D-9164 N446VBN4466vb LLC · Kalispell, MTBuilt 2020 · S/N 2208 N4470SFreitag Don M · Manhattan Beach, CABuilt 1975 · S/N D-9778 N4471EWolfe John · Marathon, FLBuilt 2001 · S/N E-3394

Back to AD 2000-23-21