Skip to content

Registered aircraft · 57,489

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

N10006Coutches Robert Hercules DBA · Livermore, CABuilt 1955 · S/N BG-72 N10007Insko Matthew T · Papillion, NEBuilt 1966 · S/N 21058839 N1000LWise Joe · Kilgore, TXBuilt 1966 · S/N TC-1000 N1000NAnderson Aerial Spraying Service Inc · Canby, MNBuilt 1963 · S/N 310H0104 N1000QErnest Obregon · Oakley, CAS/N 310P0195 N1000THaughton Douglas L · Gig Harbor, WABuilt 1957 · S/N D-4980 N1000V1kv LLC · Moultrie, GAS/N 0660 N1000YBarkhimer James C · Iraan, TXBuilt 1954 · S/N 30999 N10013Martin Ronnie D · Nebo, KYBuilt 1973 · S/N 15074753 N1001QRegistered aircraftBuilt 1962 · S/N 310H0001 N1001VLawson Justin Chadwick · Watkinsville, GABuilt 1976 · S/N R1722074 N1001XB Ryan Enterprises Inc · Lynnfield, MABuilt 2012 · S/N LIV-459 N10021Registered aircraftBuilt 2002 · S/N 30-0064 N1002QSwanson Dale A · Nashua, NHBuilt 1962 · S/N 310H0002 N1002UCsapos Larry G · Ovid, MIBuilt 1971 · S/N 15072624 N10031Taylor Douglas Scott · Fairfield, CABuilt 2000 · S/N 29-0240 N10032Sangal Tara N · Annandale, NJBuilt 1973 · S/N 15074754 N1003AOakshire Aviation LLC · Yakima, WABuilt 1978 · S/N P21000078 N1003JTownsley Doyle · Saucier, MSBuilt 1972 · S/N 10 N1003LGill David P · Seabrook, TXBuilt 2001 · S/N 29-0272 N10045Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2002 · S/N 29-0281 N10048Kumin Phillip R · Los Gatos, CABuilt 2002 · S/N 29-0282 N1004JTroxell Timothy W · Roy, WABuilt 1972 · S/N 16 N1004QChaudhary Rizvon · Louisville, KYBuilt 2000 · S/N 29-0241 N1004SRosenfeld Ronald S Trustee · Perry, MEBuilt 2003 · S/N 29-0289 N1004VSalt Aerial Aviation LLC · Hamel, MNBuilt 1976 · S/N R1722075 N10050Smith Jonathan B · Deputy, INS/N 15074761 N10051Widjokongko Antonius Maria Ario · League City, TXBuilt 1973 · S/N 15074762 N1005BRucker Casey J · West Linn, ORBuilt 1987 · S/N 4608091 N1005FBeam Douglas J Trustee · Chugiak, AKBuilt 1975 · S/N 18502677 N1005QRegistration Pending · Fairmont, WVRegistration pendingS/N 310H0005 N1005UHapka Michael · Winchester, INBuilt 1989 · S/N 25-1210 N10068Nelson Harry H · Orting, WABuilt 1973 · S/N 15074765 N1006APressley Brent DBA · Morristown, TNBuilt 2002 · S/N 29-0284 N1006UFike Brian Arthur · Florissant, COBuilt 1993 · S/N 24-3291 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 N10079Wier Michael D · Pompano Beach, FLBuilt 2002 · S/N 30-0063 N1007F007 Aviation LLC · Wilmington, DEBuilt 1968 · S/N TC-1163 N1007RUts Aviation LLC · Gainesville, VAS/N 25-0052 N1007THollar Larry · Winston Salem, NCBuilt 1973 · S/N 18262411 N1007XD&R LLC · Emory, TXS/N 34-7570182 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

Back to AD 2009-24-52