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.

N3815PNorth Louisiana Aviation LLC · Mer Rouge, LABuilt 1981 · S/N E-1850 N3815YBorean Anthony J · Olathe, COBuilt 1964 · S/N 21058315 N38166S&P Airplane Sales · Branson West, MOBuilt 1981 · S/N TC-2371 N38168Jjj&S Aviation Corp · Brooklyn, NYBuilt 1981 · S/N E-1808 N3816SKey Field Flyers LLC · Toomsuba, MSBuilt 1981 · S/N E-1806 N38173Tingley Robert D · Watham, MABuilt 1977 · S/N 34-7770289 N38175Fhg Springbrook Corp · Wilmington, DEBuilt 1981 · S/N CE-940 N3817DOff The Step Inc · Creswell, ORBuilt 1957 · S/N 34517 N3817MGulf Skies LLC · Kalispell, MTBuilt 1981 · S/N EA-191 N3817VFloener Michael A · Colville, WABuilt 1977 · S/N R1722265 N3817XPeterson Randall J · Lake Havasu City, AZBuilt 1966 · S/N 310K0217 N38180Raymond Katherine · Akron, OHBuilt 1981 · S/N 18267880 N3818XAcme Racing LLC · Overland Park, KSBuilt 1966 · S/N 310K0218 N38198Zero Mike LLC · Chattanooga, TNBuilt 1981 · S/N TC-2387 N3819XBoerne Flight Options LLC · Boerne, TXBuilt 1966 · S/N 310K0219 N3819YLaycock Justin D · Johnson City, TNBuilt 1964 · S/N 21058319 N381ACKarter Transport Enterprise LLC · Monterey, CABuilt 2007 · S/N E-3759 N381BS381bs LLC · Fresno, CABuilt 2008 · S/N 2918 N381CDN381cd Aviation LLC · Ventura, CABuilt 2005 · S/N 1432 N381CRSiemsen Randall R · Clovis, CABuilt 1976 · S/N E-875 N381DSFlightpath Investments LLC · Ottumwa, IABuilt 1974 · S/N 21060255 N381HBargainnier David R · Reedsville, PABuilt 1957 · S/N 50079 N381LMorgan Fred M · Onancock, VABuilt 1999 · S/N 29-0201 N381SBettys Beech LLC · Conway, ARBuilt 1968 · S/N TE-629 N381SPLunseth John B II · Long Lake, MNBuilt 1981 · S/N 25-0541 N381SWScorpion Oil & Gas LLC · Stafford, TXBuilt 2006 · S/N 2279 N381TCShumate Frank T · Rockport, TXBuilt 1978 · S/N TK-83 N38203Wdiaz Design Inc · Sunny Isles Beach, FLBuilt 1977 · S/N 28R7703189 N3820LFly A Twin LLC · Kirkland, WABuilt 1981 · S/N TJ-341 N3820MIsrael Howard A · Santa Monica, CABuilt 1981 · S/N TC-2372 N3820XDwyhalo David W · Moorpark, CABuilt 1966 · S/N 310K0220 N3821GI Am Alpha & Omega LLC · Sparks, NVS/N U206-0821 N3822DGifford David M · Las Vegas, NVBuilt 1957 · S/N 34522 N3822KPerry Park Investments Inc · Larkspur, COBuilt 1981 · S/N EA-192 N3822URegistration Pending · Stillwater, MNRegistration pendingBuilt 1981 · S/N D-10364 N3823AAndy Downs LLC · Langdon, NDBuilt 1981 · S/N EA-194 N3823DPfaff John W · Laytonville, CABuilt 1957 · S/N 34523 N3823UVon Pronay Nicolai A · Anchorage, AKS/N 336-0123 N3823XRegistration Pending · Logan, UTRegistration pendingBuilt 1966 · S/N 310K0223 N3824DDavis Marc · Hilsboro, ORBuilt 1957 · S/N 34524 N3824XHirschauer Jeffrey · Spokane, WABuilt 1981 · S/N CE-941 N3824YMclaren Richard T · Sturbridge, MABuilt 1964 · S/N 21058324 N3825DSelf Robert R · Tuttle, OKS/N 34525 N3825MMckendry Scott P · Sanford, NCBuilt 1981 · S/N E-1813 N3825XBliss Aviation LLC · Somerville, TNBuilt 1981 · S/N TH-1230 N3825YAtlas Mining & Mechancial Inc · Beryl, UTBuilt 1964 · S/N 21058325 N38275Von Duyke Mark A · Des Moines, WABuilt 1977 · S/N 28R-7703198 N3827DKendallville Flying Service Inc · Saint Joe, INBuilt 1957 · S/N 34527 N3827QCobb Jeff B · Atlanta, GABuilt 1981 · S/N CE-942 N3827YPrentice Ronald L · Winchester, CABuilt 1964 · S/N 21058327

Back to AD 2000-23-21