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.

N3108SLac Avionics Inc · San Jose, CABuilt 1964 · S/N 18255608 N3109CVicjen LLC · Bloomington, ILBuilt 1987 · S/N E-2400 N3109FHeligray LLC · Kalispell, MTS/N 18257209 N3109QWellink Jos · Katy, TXBuilt 1967 · S/N 18258109 N3109RHerrera Antonio P · Oxnard, CABuilt 1967 · S/N 18258509 N3109UBernadt Bruce P · Steinauer, NEBuilt 1962 · S/N 18254509 N3109WIII Per LLC · Lewes, DEBuilt 1973 · S/N TE-955 N310ACJulie Dorst LLC · Kalispell, MTBuilt 1975 · S/N 310R0290 N310ADChang Stephen · Santa Barbara, CABuilt 1976 · S/N 310R0538 N310AFSelwa Michael A · Oconomowoc, WIBuilt 1974 · S/N 310Q1121 N310AHGraydon Bilal R · Melbourne, FLBuilt 1979 · S/N 310R1660 N310AJPj Aviation Holding LLC Trustee · Eden Prairie, MNBuilt 1980 · S/N 310R1606 N310AMCwr Enterprises Inc · Henderson, NCBuilt 1979 · S/N 310R1672 N310ARHales Gutter Guys LLC · Cottonwood, AZS/N 310R1387 N310ATBelknap Scott M · Temecula, CABuilt 1965 · S/N 310J0097 N310AWBetty Eric · Old Hickory, TNBuilt 1969 · S/N 310P0231 N310BARampey Alvin H Jr · Atlanta, GABuilt 1975 · S/N 310R0065 N310BDSale Reported · Fort Wayne, INSale reportedBuilt 1965 · S/N 310J0013 N310BFGv Air Inc · Medford, ORBuilt 1978 · S/N 310R1390 N310BGFlairships LLC · Durham, NCBuilt 1977 · S/N 310R0889 N310BJJ A Flight Services LLC · Sugar Grove, ILBuilt 1973 · S/N 310Q0759 N310BLAlsager Joshua D · Kindred, NDS/N 310Q0069 N310BMTeam 67 LLC · Mount Pleasant, IABuilt 1973 · S/N 310Q0987 N310BSKwe Inc · Melbourne Beach, FLBuilt 1973 · S/N 310Q0822 N310BUTar Heel Aviation Inc · Bonita Springs, FLBuilt 1986 · S/N 4608004 N310BVExec Air Inc Of Naples · Naples, FLBuilt 1974 · S/N 310R0099 N310CBN310cb LLC · Buford, GABuilt 1975 · S/N 310R0600 N310CCLance Johnson Ministries Inc · Calhoun, GABuilt 1973 · S/N 310Q0970 N310CESwainston Ian · Las Vegas, NVBuilt 1974 · S/N 310Q1063 N310CFSouthern Illinois University DBA · Murphysboro, ILBuilt 1975 · S/N 310R0565 N310CGHoffert Stephen · Alexander, NCBuilt 1978 · S/N 310R-1304 N310CJCj Marketing Inc · Saint John, INS/N 310R0223 N310CKSt Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1980 · S/N 310R-1889 N310CLSinclair Bradley W · Melbourne, FLBuilt 1981 · S/N 310R2138 N310CTIcp Aviation LLC · Melbourne, ARBuilt 1975 · S/N 310R0570 N310CWWahl Charles · Cameron Park, CABuilt 1967 · S/N 310N-0015 N310DARecycled Air LLC · Hoschton, GABuilt 1975 · S/N 310R0186 N310DFJordan Air Inc · Hugoton, KSBuilt 1976 · S/N 310R0683 N310DHFavero Robert B · Weed, CABuilt 1974 · S/N 310Q1086 N310DLPuzio Scott M · Locust Grove, GABuilt 1966 · S/N 310K0191 N310DSWorld Marketing Syndicate I · Wilmington, DEBuilt 1977 · S/N 310R0925 N310EBWeatherproof Montana LLC · Missoula, MTBuilt 1956 · S/N 35446 N310ECState Of Tennessee · Nashville, TNBuilt 1988 · S/N TH-1534 N310EDWilson Joseph E W · Austell, GABuilt 1975 · S/N 310R0208 N310EKCassel Paul · Hernando, MSBuilt 1973 · S/N 310Q1009 N310ELFly Ivy LLC · Brighton, MABuilt 2024 · S/N 9795 N310EMTc Aviation LLC · Atlanta, GABuilt 1988 · S/N 46-08109 N310ERAlbrecht Wallace L · Fayetteville, TXBuilt 1966 · S/N 310K0187 N310ESDiamond P Aviation LLC · Riverton, ILBuilt 1973 · S/N 310Q0714 N310EWAerial Imaging Inc · South Bend, INBuilt 1973 · S/N 310Q0935

Back to AD 2000-23-21