OpenAirDocs.org
AD 2000-23-21

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
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.

N344MDBannik Leasing LLC · Orlando, FLBuilt 2018 · S/N 1781N344PGAuction Exchange Inc · Sacramento, CABuilt 2021 · S/N 2441N344SRegistered aircraftBuilt 1972 · S/N TH-210N344SGGoldman Glenn D · VaughanBuilt 1957 · S/N BG354N344SKDriver Aviation LLC · Bloomfield Hills, MIBuilt 2007 · S/N 2657N344XDavis Clint A · Fort Davis, TXBuilt 2012 · S/N 0308N344ZGlobal Pilot Inc · Wilmington, DES/N CD-231N3450FPeeler Max H · Rock Port, MOBuilt 1966 · S/N 18257450N3450SBoyes Robert Louis · Benton City, MOBuilt 1969 · S/N TC-1264N3451FBonnett Bruce J · Azle, TXBuilt 1966 · S/N 18257451N3451RBurkett Aerial Spraying · Coleman, TXBuilt 1967 · S/N 18258751N3451SChancellor Marvin E · Houston, TXBuilt 1964 · S/N 18255851N3451UJohnson Kevin S · Burns, ORBuilt 1963 · S/N 18254851N3452CDouglas Denis R · Soldotna, AKFirst renewal noticeS/N 26495N3452DRault Jaimie E · Homer, AKBuilt 1955 · S/N 32149N3452QGolden Arrow Transportation Co · Plainfield, NJBuilt 1966 · S/N 320E-0052N3452ROreagan Trenton David · Soldotna, AKBuilt 1967 · S/N 18258752N3452SWolff David Christian · Port Saint Lucie, FLBuilt 1964 · S/N 18255852N3452UNordland Tom Trustee · Boulder Junction, WIBuilt 1963 · S/N 18254852N3452YRegistered aircraftBuilt 1975 · S/N 18502882N34549Octans Aviation Co · Watertown, SDS/N TK-62N3455FN3455f Aviation LLC · New Blaine, ARBuilt 1966 · S/N 18257455N3455SAcute Holdings LLC · Jenks, OKBuilt 1964 · S/N 18255855N3455YKimmel James W · Fountain Hills, AZBuilt 1968 · S/N 18051955N3456QL & J Aviation Inc · Atwater, CABuilt 1971 · S/N 340-0004N3456UWright James R · Georgetown, CAS/N 18254856N3456YGold Michael Benjamin · Frazier Park, CABuilt 1968 · S/N 18051956N3457BChase Dennis A · Naperville, ILBuilt 1955 · S/N 35032N3457FStreet Jim A · Pilot Point, TXBuilt 1966 · S/N 18257457N3457SC Ville Flying Club · Nunica, MIBuilt 1964 · S/N 18255857N3457USelway Aviation Inc · Missoula, MTBuilt 1963 · S/N 18254857N3458FAirport Lounge Mbi LLC · Dayton, OHBuilt 1966 · S/N 18257458N3458GAmerican Aircraft Sales LLC · Livermore, CAFirst renewal noticeBuilt 1976 · S/N 310R0842N3458QIngram John · Los Angeles, CABuilt 1966 · S/N 320E-0058N3458YDelahunt David M · Simi Valley, CAS/N 18051958N3459RRtd Aviation LLC · Hillsborough, NJBuilt 1967 · S/N 18258759N3459SStg LLC · Mountain Green, UTBuilt 1965 · S/N 18255859N3459UWalker Cody · Jacksboro, TXBuilt 1963 · S/N 18254859N3459YPepper William G · Fayette, MES/N 18051959N345AMantiply Paul · Columbia, CABuilt 1957 · S/N G-64N345ACManagement Co LLC · West Columbia, SCBuilt 1977 · S/N 34-7870087N345ALItm Aircraft LLC · Charleston, SCBuilt 1974 · S/N 20700262N345AP11.10 N345ap Dst · Wilmington, DES/N 0046N345BBBaas Brian J Trustee · Cambridge, MNBuilt 1977 · S/N 18503301N345BCScalera Dominic P · West Boylston, MABuilt 1960 · S/N D-6567N345BJPerformance Aero LLC · Diamondhead, MSBuilt 2007 · S/N 015N345BKMckenzie Michael C · Ventura, CABuilt 1976 · S/N 340A0113N345CBR&E Bv LLC · Jupiter, FLBuilt 1961 · S/N D-6714N345CERich Leasing · Edmond, OKS/N 1352N345CFLowery Ron L · Batesville, ARS/N E-2532
Back to AD 2000-23-21