Skip to content

Registered aircraft · 48,627

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

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 N1002MSchuler Mark E · Columbia, ILBuilt 1970 · S/N 17259402 N1002UCsapos Larry G · Ovid, MIBuilt 1971 · S/N 15072624 N10032Sangal Tara N · Annandale, NJBuilt 1973 · S/N 15074754 N10034Whyte Henry T Jr · West Ossipee, NHBuilt 1996 · S/N 19045C N10035R H Lindsay & Assoc Inc · Canby, ORS/N 970 N1003KScott Michelle · Vallejo, CABuilt 1946 · S/N 3730 N1004MReid Brian · Boise, IDBuilt 1970 · S/N 17259404 N10050Smith Jonathan B · Deputy, INS/N 15074761 N10051Widjokongko Antonius Maria Ario · League City, TXBuilt 1973 · S/N 15074762 N1005KKing Richard J II · Rose Creek, MNBuilt 1946 · S/N 3732 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 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 N1008EEdwards Gregory S · Guthrie, OKS/N 1202-77 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 N1009AWilliams Wendell · Anchorage, AKBuilt 1950 · S/N 18581 N100AWDe La Torre Alfonso Jr · Brownsville, TXBuilt 1956 · S/N 28479 N100BVHoward Keith · Fayetteville, NCBuilt 1978 · S/N 38-78A0262 N100CGGreene Carol W · Mahwah, NJBuilt 1972 · S/N 17261191 N100CRFreudenberg Joseph B · Almira, WABuilt 1947 · S/N 5050 N100FAAlmost Heaven Aviation LLC · Morgantown, WVBuilt 1971 · S/N 15072670 N100HUSimpson Jared S · Malad City, IDBuilt 1996 · S/N 1319 N100KN18t Ltd · Wilmington, DEBuilt 1965 · S/N 17252599 N100KHLefevers Adam · Pineville, KYS/N 28529 N100MSky Odyssey Aviation LLC · Gulf Breeze, FLBuilt 1975 · S/N 17265590 N100RKEllingson Leslie B · Harwood, NDBuilt 1974 · S/N 17263551 N100SXKing Samuel E · Battle Mountain, NVBuilt 1951 · S/N 18-709 N100ULEvans Hugh E · Lafayette, LABuilt 1976 · S/N A1500634 N100WAAlcorn Stanley R · Sonora, CABuilt 1964 · S/N 17251499 N100XXAskew Stell Blake III · Durham, NCBuilt 1975 · S/N AA1B-0578 N100YAShelton Joel T · Grass Valley, CAS/N AA5-0086 N100YSLally Lawrence L · Mooresville, NCBuilt 1965 · S/N 17252400 N101Bene Mary D · Ketchum, OKBuilt 1964 · S/N 17252056 N10101Mcnaughton Robert R Jr · New Alexandria, PABuilt 1973 · S/N 15074794 N10105Wild Blue Aviation LLC · Eagle Rock, MOBuilt 1973 · S/N 15074797 N1010KCooley Joshua · Kenai, AKBuilt 1971 · S/N 2068C

Back to AD 96-09-06