Registered aircraft · 72,010

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.

N4090EAerodrome LLC · Louisville, KYBuilt 1977 · S/N 18-7809062 N4090RWiebe Aerial Applications LLC · Peabody, KSBuilt 1967 · S/N 32-40410 N4090UIsland Bound LLC · Dunedin, FLS/N 31-8152147 N40913Matlock Joshua · Squaw Valley, CABuilt 1975 · S/N 32-7540126 N40919Asb1 Group LLC · Miramar, FLS/N 31-8152162 N4091PPaulay Sandor F · Kenmore, WABuilt 1959 · S/N 23-1570 N4091ZA G Sholton Co · Wasilla, AKBuilt 1964 · S/N 18-8109 N40925High Flight Academy LLC · Allison Park, PABuilt 1973 · S/N 28-7415112 N4092RWings Of Eagles LLC · Saline, MIBuilt 1968 · S/N 32-40413 N4092WM & M Aircraft LLC · Lewis Center, OHBuilt 1967 · S/N 32-40151 N40934Southern Style Equipment LLC · Sulphur, LABuilt 1974 · S/N 32-7440071 N40935International Air Services Inc Trustee · Carson City, NVBuilt 1941 · S/N 7603 N40936Aerial Sign North Inc · Lakewood, NJBuilt 1941 · S/N 7592 N40939Grog Holdings LLC · Dallas, TXBuilt 1973 · S/N 28-7425191 N4093PLumley John J · Delray Beach, FLBuilt 1959 · S/N 23-1572 N4093XBartholomeo Daryl A · Cleveland, OKBuilt 1971 · S/N 5193 N40945Mount Eagle Inc · Alexander, ARBuilt 1974 · S/N 28-7405077 N4094PShelley Isaac R · Scottsville, VABuilt 1959 · S/N 23-1573 N40951Grant Constance R Trustee · Eaton, INBuilt 1973 · S/N 28-7425193 N40953Cws Capital Holdings LLC · Saint Petersburg, FLBuilt 1973 · S/N 28-7415118 N4095PTorell Pamela O · Port Saint Lucie, FLBuilt 1959 · S/N 23-1574 N4095YLakeland Air 6 LLC · Lakeland, FLBuilt 1981 · S/N 31-8152181 N4095ZBreidenbach Bros Inc · Iliff, COBuilt 1964 · S/N 18-8108 N40963Grant Matthew D · Alvord, TXBuilt 1974 · S/N 28-7415120 N40965Portsmouth Flying Club LLC · Epsom, NHBuilt 1973 · S/N 28-7415121 N40966Skytech Hc Ltd · Fredericksburg, OHBuilt 1973 · S/N 28-7415122 N40967Mcbroom Darrin · Des Moines, IABuilt 1973 · S/N 28R-7435146 N40969Papa Bravo LLC · Decatur, ALBuilt 1974 · S/N 28-7410052 N4096ESwiss John T · Anchorage, AKBuilt 1978 · S/N 18-7809064 N4096WCruisers Pacific LLC · Discovery Bay, CABuilt 1967 · S/N 32-40159 N4096XFoster Robert L Jr · Chandler, OKBuilt 1970 · S/N 5196 N4096ZTurner Hal Eugene Jr · Tiburon, CAS/N 18-8110 N40972Terry Aaron D · Glendale, AZS/N 28-7425196 N40978Dodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 31-8152199 N4097KSwag Aviation LLC · Labelle, FLBuilt 1981 · S/N 31-8152191 N4097MN4097m LLC · Boynton Beach, FLBuilt 1998 · S/N 17280322 N4097XWilson Dane A · Church Point, LABuilt 1971 · S/N 5197 N4097ZSullivan Daniel J · Long Lake, MNBuilt 1964 · S/N 18-8111 N40982Seneca Aviation LLC · Wheaton, MDBuilt 1974 · S/N 34-7450095 N40984Four Zero Niner LLC · Granger, IABuilt 1973 · S/N 28-7425199 N40987Besl Thomas J · Cincinnati, OHBuilt 1973 · S/N 28-7415126 N4098AJaa Holdings LLC · Springfield, ILBuilt 1981 · S/N 31-8152200 N4098FN4098f LLC · Ypsilanti, MIBuilt 1976 · S/N 28-7715004 N4098RLawler Christy · Livingston, MTBuilt 1968 · S/N 32-40406 N4098XOstgard William R · Mims, FLS/N 5198 N4098ZChant J Archie · Riverton, WYBuilt 1964 · S/N 18-8112 N40992Awmr LLC · Conroe, TXBuilt 1982 · S/N 31-8252045 N40993Premier Capital Enterprises LLC · Hurricane, UTBuilt 1974 · S/N 28-7405159 N4099EReel Chad · Wasilla, AKS/N 18-7809066 N4099NS O Witt And Associates LLC · Ridgecrest, CAS/N 680174

Back to AD 87-10-06 R1