Registered aircraft · 47,138

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.

N165LRAircraft Trustee Services Inc Trustee · Dover, DES/N 0632 N165MHFortune Kyle D · Hampstead, NCBuilt 1966 · S/N 310K0173 N165MRDavid Rever Aviation LLC · Dewey Beach, DEBuilt 1962 · S/N CD-459 N165MWN723 LLC · Denver, COBuilt 2016 · S/N 1420 N165NHExpert Aircraft Thinking & Restoration LLC · Wilmington, DEBuilt 1984 · S/N 18268382 N165RWCw Aircraft LLC · Atlanta, GABuilt 1964 · S/N TC-683 N165SRN165sr LLC · Waterford, VABuilt 2006 · S/N 1941 N165TVSwanland Robert C · Grants Pass, ORBuilt 1960 · S/N 4189 N165WFHardin John M · Terrell, TXBuilt 1962 · S/N 210-57875 N1660BKanode William E · Delaware, OHS/N 17268123 N1661MTurbo Tech Investments LLC · Montrose, COBuilt 1975 · S/N 18264406 N1662RGray Jerry B · Valdez, AKBuilt 1974 · S/N 18502385 N1663COlson Aviation LLC · Chandler, AZBuilt 2003 · S/N 0585 N1663RSmith Dan V · Anchorage, AKBuilt 1974 · S/N 18502386 N1665CTaylorsville Lake Marina Inc · Simpsonville, KYBuilt 2003 · S/N 0587 N1667MTen Mile Ranch Inc · Vale, ORBuilt 1971 · S/N 18501859 N1668MRocky Mountain High Aviation LLC · Louisville, COBuilt 1975 · S/N 18264409 N1668TKevu Aviators LLC · Maryville, MOBuilt 1973 · S/N 414-0461 N1668UUngalik Syndicate LLC · Unalakleet, AKBuilt 1975 · S/N 20700268 N1669Berardinelli Michael A · Meridian, IDBuilt 1955 · S/N 31946 N1669MC Y Transport LLC · Columbus, MNBuilt 1971 · S/N 18501861 N1669WBahri Kiumars · Birmingham, ALBuilt 1972 · S/N CE-392 N166ABSafford Aviation Service Inc · Coolidge, AZBuilt 1981 · S/N 34-8133134 N166AMColvin Clu D DBA · Big Cabin, OKBuilt 1963 · S/N 310H0127 N166BWings Of Hope Inc · Chesterfield, MOBuilt 1972 · S/N CD-1293 N166BGColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 2023 · S/N 9505 N166BVSensing Aviation LLC · Nashville, TNBuilt 2000 · S/N TH-1958 N166CAMca Aviation LLC · Cartersville, GABuilt 2026 · S/N 11117 N166CCValkyrie Aero LLC · Mesa, AZBuilt 1954 · S/N CG-21 N166DGDg Air LLC · Oakland, TNS/N 18267796 N166JBEp Aviation LLC · Wynne, ARS/N 18262300 N166MDDoan Aviation LLC · New Hope, PABuilt 2024 · S/N 10260 N166PGFlyers Aloft LLC · Winter Park, FLBuilt 2008 · S/N 1948 N166RTTalgrad Aviation LLC · Cumming, GABuilt 2007 · S/N 2687 N166SMRegistered aircraftRegistration pending, pending cancellationBuilt 2023 · S/N 9461 N166SRAvepartners LLC · Hope Mills, NCBuilt 2007 · S/N 1764 N166TRBourn Bryan · Jordan, MNBuilt 2002 · S/N 0264 N166TTTruex Paul F · Sarasota, FLBuilt 2010 · S/N 411156 N166ZUsda Forest Service Fire & Aviation · Boise, IDBuilt 1986 · S/N U20606923 N16708Lucia G Keith · Pleasant Hill, CABuilt 1967 · S/N 2016 N1670CAlaska Freight Services LLC · Fairbanks, AKBuilt 1953 · S/N 30370 N1670MFirebird Aviation LLC · Tempe, AZBuilt 1975 · S/N 18264410 N1670THyde Family Aviation LLC · Wilmington, DEBuilt 1973 · S/N 414-0463 N1671RDavis Ronald L Jr · Soldotna, AKBuilt 1974 · S/N 18502394 N1671WAviatech Inc · Tamarac, FLBuilt 1972 · S/N D-9382 N1673MBower Ashley R · Anchorage, AKBuilt 1971 · S/N 18501865 N1673THarvey Alan G · Dallas, TXBuilt 1981 · S/N E-1895 N1673WOci Ltd · Brunswick, GABuilt 1972 · S/N TH-258 N1674CFarwest Aviation LLC · Billings, MTBuilt 1953 · S/N 30374 N1674WLipps Charles J · Fairview, OKBuilt 1972 · S/N CD-1298

Back to AD 2000-23-21