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.

N367PCReynolds Doug · Huntington, WVBuilt 2007 · S/N E-3795 N367PTHalcomb Robby · Burleson, TXBuilt 2012 · S/N 3854 N367TJFlorida Aerial Services Inc · Lutz, FLBuilt 1975 · S/N 18263721 N367TMTm Ventures LLC · Missoula, MTBuilt 2009 · S/N 3590 N367XBreuer Chad R · Lometa, TXBuilt 1976 · S/N 6165C N367ZKrs Air & Cattle LLC · Durham, CABuilt 1960 · S/N CD-252 N3680CBindon Phil E · Wasilla, AKFirst renewal noticeBuilt 1954 · S/N 31179 N3680RYatra Global LLC · Bedford, MABuilt 1980 · S/N E-1717 N3680UMoughon Kirby W · Melbourne, FLBuilt 1980 · S/N E-1718 N3681DGcsw Holdings Inc · Poplar Grove, ILBuilt 1956 · S/N 35381 N3681GRed Wolf Aviation LLC · Wilmington, DEBuilt 1980 · S/N TH-1157 N3681YJeff Blue Corp · Seminole, FLS/N 21058181 N36822Bream Bruce L · Beachwood, OHBuilt 1978 · S/N 28R-7803345 N36827Thaviation LLC · Louisville, KYBuilt 1978 · S/N 34-7870374 N36829Prime Aviation LLC · Wilmington, DEBuilt 1980 · S/N E-1720 N3682CKiger Lance B · Prairieville, LAS/N 31181 N3682DLasseter Granville D II · Richmond, TXBuilt 1956 · S/N 35382 N3682ZIliamna Air Taxi Inc · Iliamna, AKBuilt 1980 · S/N TH-1159 N36846Armbruster LLC · Amherst, OHBuilt 1979 · S/N 310R1600 N36847Thrash Howard G II · Lubbock, TXBuilt 1980 · S/N EA-115 N3684ARegistered aircraftBuilt 1980 · S/N CE-916 N3684HAvex X Corp · Coral Gables, FLBuilt 1981 · S/N TE-1180 N3684UToews Berton J · Casper, WYBuilt 1963 · S/N 18255084 N3684YBluebird Holdings LLC · Morris, MNFirst renewal noticeBuilt 1980 · S/N TJ-298 N36855Aerial Digital Images LLC · Huntington Beach, CABuilt 1980 · S/N EA-117 N3685WJewell Warren · Seattle, WABuilt 1980 · S/N EA-113 N3685YWhite Lawrence L III · La Habra, CABuilt 1963 · S/N 21058185 N36862Linville Keith · Bend, ORBuilt 1979 · S/N 310R1605 N3686BBrosius John W III · Dell Rapids, SDBuilt 1962 · S/N NAV42419 N3686CSedwick William R · Anchorage, AKBuilt 1954 · S/N 31185 N3686UEnvi Adventures LLC · Troutdale, ORBuilt 1963 · S/N 18255086 N3686YEllis Air LLC · Acworth, GAS/N 21058186 N36877Stilwell Aviation LLC · Stilwell, KSBuilt 1980 · S/N EA-119 N36884Main Aviation Inc · Visalia, CABuilt 1980 · S/N EA-121 N36885Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N 340A0681 N36887Aa Aircraft Adventure LLC · Joplin, MOBuilt 1982 · S/N 414A0835 N3688CDiedrich Steve A · Sandpoint, IDBuilt 1954 · S/N 31187 N3688RMckay Christopher · Point Arena, CAS/N CE-918 N3688UTaylor Aviation Inc · Fort Benton, MTBuilt 1963 · S/N 18255088 N3689ULeonard Robert E · Mattoon, ILBuilt 1980 · S/N E-1733 N368BVinnola Bruce L · Glenrock, WYBuilt 1957 · S/N D-5107 N368CDSavfar Aviation Inc · Wilmington, DEBuilt 2004 · S/N 1071 N368CMKraemer Jeffrey J · Cold Spring, MNBuilt 2005 · S/N 29-0368 N368DMNosrati David · Beverly Hills, CABuilt 2007 · S/N 2433 N368FDOakes Farms Food & Distribution Services LLC · Naples, FLBuilt 2019 · S/N 4858 N368HPHigh Performance Aircraft Inc · El Cajon, CABuilt 1981 · S/N E-1833 N368JEJones Enterprises · Nacogdoches, TXBuilt 1980 · S/N TH-1145 N368JHUrsine L Attitudes Ltd · Richland, WABuilt 1981 · S/N E-1920 N368MWAvalanche Aviation LLC · Ogden, UTBuilt 2021 · S/N 2313 N368POfferaire Inc · Lebanon, NJBuilt 1995 · S/N E-2942

Back to AD 2000-23-21