Skip to content

Registered aircraft · 44,766

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:81-15-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-15-03') 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:81-15-03')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-15-03')
  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:81-15-03')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-15-03')
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.

N1000NAnderson Aerial Spraying Service Inc · Canby, MNBuilt 1963 · S/N 310H0104 N1000SButler County Warbirds Inc · Middletown, OHBuilt 1972 · S/N AA5-0107 N10013Martin Ronnie D · Nebo, KYBuilt 1973 · S/N 15074753 N1001MRocky Mountain Ventures Inc · Cheyenne, WYBuilt 1970 · S/N 17259401 N1001QRegistered aircraftBuilt 1962 · S/N 310H0001 N1002MSchuler Mark E · Columbia, ILBuilt 1970 · S/N 17259402 N1002QSwanson Dale A · Nashua, NHBuilt 1962 · S/N 310H0002 N1002UCsapos Larry G · Ovid, MIBuilt 1971 · S/N 15072624 N10032Sangal Tara N · Annandale, NJBuilt 1973 · S/N 15074754 N1004MReid Brian · Boise, IDBuilt 1970 · S/N 17259404 N1004PVankirk Malcolm R · Frederick, MDBuilt 1954 · S/N 23-6 N10050Smith Jonathan B · Deputy, INS/N 15074761 N10051Widjokongko Antonius Maria Ario · League City, TXBuilt 1973 · S/N 15074762 N1005FBeam Douglas J Trustee · Chugiak, AKBuilt 1975 · S/N 18502677 N1005QRegistration Pending · Fairmont, WVRegistration pendingS/N 310H0005 N10068Nelson Harry H · Orting, WABuilt 1973 · S/N 15074765 N10070Red Dog LLC · Sicklerville, NJS/N 15074767 N10072Czupich Holly Nicole · Maumee, OHS/N 15074769 N10073Brown Charles A · Boise, IDBuilt 1973 · S/N 15074770 N10075Gausman Grace K · Lompoc, CABuilt 1973 · S/N 15074771 N10076Gamm Stephen Wade · Warrenton, VABuilt 1973 · S/N 15074772 N10077Caudle John Edwin II · Arlington, TXBuilt 1973 · S/N 15074773 N1007THollar Larry · Winston Salem, NCBuilt 1973 · S/N 18262411 N10082Go Leasing Company · Phillipsburg, KSBuilt 1973 · S/N 15074778 N10085Souza Samuel J · Gainesville, GAS/N 15074781 N10086Motley Steven A · Winter Garden, FLBuilt 1973 · S/N 15074782 N10089Saucier Anthony J · La Mesa, CABuilt 1973 · S/N 15074785 N1008MHottenstein William R · Kingston, PABuilt 1970 · S/N 17259408 N10092Steckowski Stephan O · Eastman, GABuilt 1973 · S/N 15074788 N10096Elite Fleet Jacksonville LLC · Jacksonville, FLBuilt 1973 · S/N 15074791 N10098Hobbs Adam C · Monroe, WABuilt 1973 · S/N 15074793 N1009QWatson James E Jr · Victor, COBuilt 1962 · S/N 310H0009 N100AWDe La Torre Alfonso Jr · Brownsville, TXBuilt 1956 · S/N 28479 N100CAFass Flyers LLC · Garden Ridge, TXBuilt 1978 · S/N 18266536 N100CGGreene Carol W · Mahwah, NJBuilt 1972 · S/N 17261191 N100EMKentem100 LLC · Asheboro, NCBuilt 1981 · S/N 31-8152196 N100FAAlmost Heaven Aviation LLC · Morgantown, WVBuilt 1971 · S/N 15072670 N100FPFlying Particles Inc · Livermore, CABuilt 1974 · S/N 18262957 N100KN18t Ltd · Wilmington, DEBuilt 1965 · S/N 17252599 N100KFAlbrecht Douglas D · Hobart, INBuilt 1966 · S/N 18257496 N100KHLefevers Adam · Pineville, KYS/N 28529 N100LDPenning Jeffrey D · Clear Lake, IABuilt 1968 · S/N 17700990 N100LYLyon Aviation Inc · Pittsfield, MAS/N 31-8052064 N100MSky Odyssey Aviation LLC · Gulf Breeze, FLBuilt 1975 · S/N 17265590 N100POut Island Magic LLC · Gainesville, FLBuilt 1982 · S/N 31-8252019 N100RKEllingson Leslie B · Harwood, NDBuilt 1974 · S/N 17263551 N100SDDivan Jeremy E · Castle Rock, COBuilt 1960 · S/N 52853 N100SLOlson Gordon N · Racine, WIBuilt 1971 · S/N 18260900 N100TBAlexander Aviation LLC · Brighton, COBuilt 1963 · S/N CD-637 N100UDVogel Kelly C · Ventura, CAS/N 15070071

Back to AD 81-15-03