Skip to content

Registered aircraft · 72,007

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

N3200WBrickley Brian J · Manchester, MIBuilt 1964 · S/N 32-04 N3200ZBrady Michael E · Buffalo, NYBuilt 1959 · S/N 22-7140 N32019Spicher Samuel Charles · Harrisonburg, VABuilt 1974 · S/N 28-7505017 N3201GArdent Aviation LLC · Salt Lake City, UTBuilt 1978 · S/N 24-0565 N3201LFowler Scott A · Lakeland, FLBuilt 1978 · S/N 24-0566 N3201ZMcclain William J · Corona, CABuilt 1959 · S/N 22-7141 N32020N32020 LLC · Springfield, MOBuilt 1974 · S/N 28R-7535015 N32025Biafora Joseph R Jr · Panorama City, CABuilt 1974 · S/N 28-7510008 N3202SCramer Traci · Hatfield, PABuilt 1996 · S/N 1111S N32030Robert Starr · Schofield, WIBuilt 1974 · S/N 28-7515048 N32037Conyers Jeffrey P · Sevierville, TNBuilt 1974 · S/N 32-7540009 N3203FChampagne Anthony J · Prairieville, LABuilt 1967 · S/N 670123 N3203MDavid Dorin A · Kasilof, AKBuilt 1947 · S/N 12-1873 N32042Van Anda Aviation LLC · Apopka, FLBuilt 1974 · S/N 28-7515052 N32043Brolan Aviation LLC · Kansas City, MOBuilt 1974 · S/N 28-7515053 N32047Sat Aircraft LLC · Clermont, FLBuilt 1974 · S/N 28R-7535018 N32052Risley Bryan D · Bartow, FLBuilt 1974 · S/N 28-7525016 N32056Steuer Christopher · Plumas Lake, CABuilt 1974 · S/N 28-7515056 N32059Coast Property Inc · Nipomo, CABuilt 1974 · S/N 28-7505021 N3205BDurben Robert W · Newcomerstown, OHBuilt 1953 · S/N 22-2032 N3205FHawkins William J II · Saint Petersburg, FLS/N 680002 N3205JSchumacher Eraine · Hague, NDBuilt 1958 · S/N 1238 N32066Chadwick Cobb Kristy L · Tallahassee, FLBuilt 1974 · S/N 28-7515059 N32067Legeros David · Brooklyn, NYS/N 28-7515060 N32068Christensen Gary L · Royal City, WABuilt 1974 · S/N 28-7515061 N32069Adb Investments LLC · Duncan, SCBuilt 1974 · S/N 28-7515062 N3206EMorey Airplane Company Inc · Middleton, WIBuilt 1978 · S/N 17271467 N32070Williams Seth M · Jeanerette, LAFirst renewal noticeS/N 28-7505022 N3207EArmstrong Aviation LLC · New Orleans, LABuilt 1978 · S/N 17271468 N3207FGoodwin Winston L · Cypress, TXBuilt 1967 · S/N 670361 N3207PTraverse Air Inc · Traverse City, MIBuilt 1957 · S/N 23-1147 N3207RLingerfelt Joseph A · Woodburn, ORBuilt 1969 · S/N 28R-31129 N3207WZero Seven Whiskey LLC · Norco, CABuilt 1965 · S/N 32-7 N320827550g LLC · Birmingham, MIBuilt 1974 · S/N 28-7515065 N32089Vosberg Jeffrey A · Norwalk, IABuilt 1974 · S/N 28-7510012 N3208AKreitel Cody James · Anchorage, AKBuilt 1953 · S/N 25852 N32095Rogers Dekishon W B · Atlanta, GABuilt 1974 · S/N 28-7525021 N32097Seniram Air Inc · Wilmington, DEBuilt 1975 · S/N 28-7515067 N32099Odland Steve E · Luverne, MNBuilt 1974 · S/N 28-7515068 N3209PMg Renewal Corp Inc · Salt Lake City, UTFirst renewal noticeBuilt 1957 · S/N 23-1150 N320AGBusenbark Kenneth A · Niceville, FLBuilt 1991 · S/N 37032012614P2 N320AJDaedalus Wings Inc · Malvern, OHBuilt 2011 · S/N 77FB N320AKMclauchlin Todd · Sparks, NVBuilt 2001 · S/N 3841 N320BDDavis Burton D · Jefferson, IABuilt 2023 · S/N 906-320-747 N320BMSchenk Jonathan M · Amarillo, TXFirst renewal noticeBuilt 2019 · S/N 96M N320BSPriewe Steve R · Sardis, MSBuilt 2001 · S/N 357-320-115 N320BWWinterberg Brian D · Garberville, CABuilt 1997 · S/N 770-320-612FB N320CLSantiago Carlos M · Davis Junction, ILBuilt 2013 · S/N 002 N320CPPhilpott John C · Newbury Park, CABuilt 2015 · S/N 72661 N320DDBronson Robert D Trustee · Prineville, ORBuilt 1972 · S/N 17261193

Back to AD 87-10-06 R1