Registered aircraft · 20,481

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N786TFAmerican Corporate Executive Services · Plantation, FLBuilt 2008 · S/N 20608316 N7870AMerriman John R · Georges Mills, NHBuilt 1957 · S/N 32767 N7871ACantrell Dennis Owner · Conway, ARBuilt 1957 · S/N 32768 N78720Sale Reported · Greeley, COSale reportedBuilt 1973 · S/N 18261776 N78737Meyer Rex · Harmon, ILBuilt 1973 · S/N 18261778 N7874J2f Trade LLC · Collinsville, TXS/N 21060597 N7878WRegistered aircraftBuilt 1978 · S/N 18052936 N787AECoordinate Productions LLC · Waterloo, IABuilt 1972 · S/N 21059799 N787DAMeade Gregory J · Santa Margarita, CABuilt 1966 · S/N 18257284 N787DCChavers Seaborn W Jr · Stamping Ground, KYBuilt 1980 · S/N 18267611 N787DDHyde James C · Clifton, VABuilt 1977 · S/N 18265896 N787MDGeorgia Forestry Commission · Macon, GABuilt 2011 · S/N 18282308 N78801Stone William · Lexington, KYBuilt 1973 · S/N 18261785 N7882AWayner Paul S · Anchorage, AKBuilt 1957 · S/N 32779 N7884AMcintyre Jon D · Fairbanks, AKBuilt 1957 · S/N 32781 N788CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281777 N788MKRabin Michael D · Charlottesville, VAS/N 18268233 N788PWilliam Earl Dixon LLC · Lumberton, NCBuilt 1968 · S/N 18259337 N788RMVan Bortel Aircraft Inc · Arlington, TXBuilt 2012 · S/N 18282321 N7890ARobinson Stephen K · Davis, CAS/N 32787 N7896SPanepinto Lane · Lafitte, LABuilt 1967 · S/N U2060814 N789DMAllen Gary D · Eyota, MNS/N 18266555 N789GTJj Hughes Logistics LLC · Canyon, TXS/N R18200561 N789TCMadden Contracting Co Inc · Minden, LABuilt 2000 · S/N 18280788 N78BKKang Byung · Kansas City, MOBuilt 2024 · S/N 18283277 N78DEStanley Ryan G · Mossyrock, WAS/N 18503701 N78FWoods Joseph Lee · Gilbert, AZBuilt 1963 · S/N 21058258 N78FGMcclanahan John B · Fayetteville, GAS/N 18255224 N78KWVolz James R · Laredo, TXBuilt 1974 · S/N U20602647 N78LHL & J Adventures LLC · Paris, OHBuilt 1978 · S/N 18266426 N78MKNelleh LLC · Liberal, KSBuilt 1978 · S/N 21062587 N78MWSymple Consulting LLC · Topeka, KSBuilt 1976 · S/N U20603205 N78PCBombach James · Katy, TXBuilt 1976 · S/N 18264893 N78RGBubber Inc · Lake Providence, LABuilt 1977 · S/N R18200057 N78RRWilkinson William H · Anchorage, AKBuilt 1973 · S/N 18261689 N78WESouth Delta Aviation Inc · West Helena, ARBuilt 2000 · S/N 18280832 N78WRSwift Aviation LLC · Lampasas, TXBuilt 1977 · S/N 18265385 N78WVOrange Motion Trading LLC · Las Vegas, NVBuilt 1977 · S/N 21062214 N7901PTwo Brothers LLC · Helena, MTBuilt 1969 · S/N 18259640 N7901VBoeder Bradley M · Lakewood, WABuilt 1966 · S/N 18051801 N7904VKlinkmueller Kurt · North Pole, AKS/N 18051804 N79074Arrol Keith C · Fairfield, CABuilt 1973 · S/N 18261790 N790SATavern Aviation LLC · Tavernier, FLBuilt 2001 · S/N 20608160 N79107Rosequist Christopher Conrad Trustee · Moyie Springs, IDBuilt 1973 · S/N 18261795 N7910VReifel Christopher · Eagle River, AKS/N 18051810 N7911VBig Bend Community College · Moses Lake, WABuilt 1966 · S/N 18051811 N79128Hawkins Jeffery D · Mandeville, LABuilt 1973 · S/N 18261799 N79140Cho Jong Hoon · Rch Palos Vrd, CAS/N 18261801 N7914VTerry James R · Glenwood Springs, COBuilt 1966 · S/N 18051814 N7917NWrangell Mountain Air Inc · Palmer, AKBuilt 1977 · S/N U20603720

Back to AD 84-10-01 R1