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.

N3309SCessna 210 N3309s LLC · Yellville, ARBuilt 1969 · S/N 21059109 N3309XCabanas Alexis Santiago · Stroudsburg, PAS/N 310L-0159 N3309YRuschak Donald A · Charleroi, PABuilt 1962 · S/N 18254309 N330ATTower Capital Aircraft Holdings LLC · San Antonio, TXBuilt 2022 · S/N 8936 N330BDD & J Holdings LLC · Ellis, IDBuilt 1973 · S/N 18261634 N330CAOsborn Richard H · Bakersfield, CABuilt 1965 · S/N TC-904 N330CDDec Enterprises LLC · Naples, FLBuilt 2005 · S/N 1319 N330CFFox Claire S · Los Angeles, CABuilt 2007 · S/N 31-0067 N330CLCoalos Inc · State College, PANon-citizen corporation, flight hours not reportedS/N CD-488 N330DJPrecision Aviation Specialty Services LLC · Bay Minette, ALBuilt 1992 · S/N CE-1707 N330DPAdvanced Commercial Group LLC · Helena, MTBuilt 2005 · S/N 1417 N330FSkydive Wayland LLC · Melbourne, FLBuilt 1957 · S/N 34329 N330FFFarrington Aviation LLC · Houston, TXBuilt 2006 · S/N WCR-107 N330GBBrenner Gary L · Mission Viejo, CABuilt 1975 · S/N 18264242 N330HCTf Op LLC · Houston, TXBuilt 2023 · S/N 9223 N330LCDe Witt Luba Owner Trustee · Fort Lauderdale, FLBuilt 1980 · S/N P3370352 N330MRJett Aviation LLC · Clovis, NMBuilt 1979 · S/N 340A0721 N330RMCastle Rock Services LLC · Helena, MTBuilt 1996 · S/N LIV-044 N330STBon Air LLC · Chickasha, OKBuilt 2026 · S/N 11292 N330WH2k Partners LLC · Dallas, TXBuilt 1989 · S/N CE-1322 N330ZVinciguerra Wayne D · Sutter Creek, CABuilt 1960 · S/N CD-227 N3310DGrewe Mike · Lake In The Hills, ILBuilt 1972 · S/N 310Q-0630 N3310RSeitz Martin V · Brookfield, WIBuilt 1967 · S/N 18258610 N3310YRegistration Pending · Fayetteville, ARRegistration pendingS/N 18254310 N3311DPendergrass Joseph M · Wasilla, AKBuilt 1955 · S/N 32109 N3311RView From Above Inc · Columbia, CABuilt 1967 · S/N 18258611 N3311SExperimental Aircraft Association Inc · Oshkosh, WIBuilt 1969 · S/N 21059111 N3311UBeck Gary · Albuquerque, NMBuilt 1963 · S/N 18254711 N3311YChavez Rafael J · Santa Fe, NMBuilt 1962 · S/N 18254311 N3312FWill Robert J · Fall City, WABuilt 1966 · S/N 18257312 N3312RParish Mark · Earth, TXBuilt 1967 · S/N 18258612 N3312SBas Part Sales LLC · Greeley, COBuilt 1969 · S/N 21059112 N3312URoberts Air Inc · Goodwin, ARBuilt 1963 · S/N 18254712 N3313HTriple H Capital Holdings LLC · Newark, DEBuilt 2019 · S/N 2041 N3313ULayton Robert H · Seminole, TXBuilt 1963 · S/N 18254713 N3313XBowman Cody · Brooklyn, MIBuilt 1967 · S/N 310L-0163 N3313YCosta Flying Service Inc · Painted Post, NYS/N 18254313 N33144Weather Modification LLC · Fargo, NDBuilt 1975 · S/N 34-7570094 N3314YSimas Filomeno M · Grover Beach, CABuilt 1962 · S/N 18254314 N33156Bchr Aviation LLC · Boerne, TXBuilt 1975 · S/N 34-7570096 N3315AG A Davis LLC · Las Vegas, NVS/N TC-1355 N3315FSabbe Bros Flying Service Inc · Maddock, NDFirst renewal noticeBuilt 1966 · S/N 18257315 N3315QTcf Ventures LLC · Wilmington, DEBuilt 1966 · S/N 320D0115 N3315RTriple X Construction Inc · Camp Verde, AZBuilt 1967 · S/N 18258615 N3315VWirth Nicholas · Lake Geneva, WIBuilt 1977 · S/N R1722248 N3315XElberg Paul · Aventura, FLBuilt 1967 · S/N 310L0165 N33167Twincat Aero LLC · San Diego, CABuilt 2021 · S/N 2311 N3316QPerson Michael · West Chester, PABuilt 1966 · S/N 320D0116 N3316RBranstetter Jack · Ponca City, OKS/N 18258616 N3317FPeniston Mandy J · Chillicothe, MOBuilt 1966 · S/N 18257317

Back to AD 2000-23-21