Skip to content

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.

N2093GNew Herschel Dudley Jr · Savannah, GABuilt 1958 · S/N 51393 N2093WKliewer Silas M · Ulm, MTBuilt 1966 · S/N D-8039 N20944Moody Robert L · Ava, MOFirst renewal noticeBuilt 1972 · S/N 18261313 N20946Local News LLC · Janesville, WIBuilt 1972 · S/N 18261315 N20947Williams Harry D III · Frostproof, FLS/N GK-50 N20948Wallin Rolf B · Fayetteville, NCBuilt 1972 · S/N 18261316 N2094VCorning James Elmon · Flagstaff, AZS/N 28R-7931109 N20955Dimich Milan C · La Jolla, CABuilt 1972 · S/N 18261320 N2095GRegistration Pending · Bozeman, MTRegistration pendingS/N 51395 N2095RTyson John H · Melba, IDS/N 18255295 N2095VMoon Christopher · Guyton, GABuilt 1979 · S/N 28R-7931110 N2095XMiller Michael D · Goffstown, NHBuilt 1965 · S/N 18256195 N20962Fairmont Field LLC · Enid, OKBuilt 1972 · S/N 18261324 N20966Gibson Todd W · Madisonville, LABuilt 1972 · S/N 18261327 N20969Kembel Robert D · Saint Ignatius, MTBuilt 1976 · S/N 18503049 N2096RBeasley Tim · Summerland Key, FLBuilt 1964 · S/N 18255296 N2096XSeward Mark · Seattle, WABuilt 1979 · S/N 28-7921007 N20970Hitt James Randy · Blue Springs, MSBuilt 1972 · S/N 18261330 N20972Esmiol Matthew · Marlborough, CTBuilt 1972 · S/N 18261331 N20975American Union Printing Inc · Chino Valley, AZBuilt 1972 · S/N 18261333 N20976Kwolik Jordan M · Mckinney, TXBuilt 1972 · S/N 18261334 N20978Crosswinds Flying Club Inc · Oakland, MIBuilt 1972 · S/N 18261336 N2097RWilson Wayne D · Saratoga Springs, NYBuilt 1964 · S/N 18255297 N2097XSouth Carolina Forestry Commission · Columbia, SCBuilt 1965 · S/N 18256197 N20980White Duane A · Wappingers Falls, NYBuilt 1972 · S/N 18261337 N20986Skylane Flying Club Inc · Omaha, NEBuilt 1972 · S/N 18261342 N2098WHolland Greg R · Irvine, CABuilt 1966 · S/N CE-9 N2098XKuefler Michael J · Saint Ignatius, MTBuilt 1965 · S/N 18256198 N2099GHilten Robert W · Columbus, MTBuilt 1958 · S/N 51399 N2099XGreen Glen A · Willits, CABuilt 1965 · S/N 18256199 N209DCDelaware Corp · Topping, VABuilt 1979 · S/N 414A0229 N209DWWhite Columbia Inc Trustee · Wilmington, DEBuilt 2005 · S/N 41504 N209FKnight Air Inc · Asheboro, NCBuilt 2018 · S/N 33-0010 N209HWWep Ent LLC · Graford, TXBuilt 2004 · S/N 29-0330 N209JAHowen Kyle Verne · San Luis Obispo, CABuilt 2016 · S/N 4309 N209KSSchneider Kerry · Alpine, WYS/N P21000560 N209MEUnbound Aviation LLC · Kalispell, MTBuilt 2021 · S/N 2366 N209MPInks Allen W · Boerne, TXBuilt 1988 · S/N CE-1285 N20ACOwen Ray L · Los Gatos, CABuilt 1972 · S/N D9371 N20BRYork Stanley A · Leetonia, OHBuilt 1955 · S/N 31563 N20CNuxoll Randy G · Eagle, IDS/N P3370145 N20CAState Of California Department Of Transportation · Sacramento, CABuilt 2019 · S/N 4844 N20CDCording Christopher Robert · Wendell, NCBuilt 1999 · S/N 1006 N20CHRegistered aircraftBuilt 1974 · S/N 18263453 N20CVRoss Craig L · New Castle, DEBuilt 2005 · S/N 1532 N20DEEbright Sean E · Hasty, COS/N 51334 N20DJBeach Bum Airways LLC · Saint Petersburg, FLBuilt 1966 · S/N TE-191 N20DMLowe Aviation Co · Macon, GABuilt 1973 · S/N 27-7305066 N20DPErvin Eric · La Follette, TNBuilt 1988 · S/N 4608140 N20FCLge Flying Club Inc · Marietta, GABuilt 1970 · S/N 18260314

Back to AD 2000-23-21