Registered aircraft · 250

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-12-09-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-12-09-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-12-09-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-12-09-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-12-09-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-12-09-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.

N20LVSilver Skyways LLC · Las Cruces, NMBuilt 1986 · S/N 686 N20NBStauffer Michael S · Wichita Falls, TXS/N 557 N20NCJohnson Professional Aviation LLC · League City, TXS/N 559 N20NDSheff Donald · Redwood City, CAS/N 687 N20SNHealy Edward · Fort Atkinson, WIBuilt 1987 · S/N 746 N20TBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 2008 N20TLN20tl LLC · Incline Village, NVBuilt 1987 · S/N 749 N20VCDanny J Daigle LLC · Greenville, MES/N 782 N20VTRegistered aircraftS/N 899 N214GTAcba Inc Trustee · Wilmington, DEBuilt 2003 · S/N 2214 N219RTSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2003 · S/N 2189 N219SDFreund Gregor · San Francisco, CABuilt 2001 · S/N 2050 N219WEFinnegan Dennis M · Novato, CABuilt 1994 · S/N 1695 N21ARClarkson Jeffrey D · Park Rapids, MNS/N 755 N221AMOctopus Flying Club Inc · Riverdale, MDBuilt 1998 · S/N 1856 N228GHopkins Boone K · Saint Simons Is, GAS/N 612 N241GTBroshchan Ruslan A · Jackson, MSS/N 2141 N242GT25125 Inc · Wilmington, DEBuilt 2001 · S/N 2042 N242ZZSpace Coast Aircraft Co · Merritt Island, FLS/N 2080 N245LCImage Craft LLC · Phoenix, AZBuilt 2001 · S/N 2045 N24TAN24ta LLC · Wilmington, DEBuilt 1984 · S/N 457 N2501NMarch Peter J · Peotone, ILS/N 900 N2503DAlnico Aviation LLC · Lafayette, INS/N 864 N2504BHatz Aeronautics LLC · Pompano Beach, FLBuilt 1989 · S/N 862 N2507TCoscarelli Guillrtmo H · Wailuku, HIS/N 914 N25096Green Air LLC · Novato, CAS/N 961 N2509XOrsippus Management LLC · El Dorado Hills, CAS/N 951 N2510KFugate Sandra S · Louisville, KYBuilt 1989 · S/N 877 N251251 Ace Distributers Inc · Arlington, WAS/N 962 N2512RMartin Randolph · Springfield, ILBuilt 1989 · S/N 913 N2519TDouglas James E · Fallbrook, CAS/N 949 N25219Octopus Flying Club Inc · Riverdale, MDS/N 970 N2521NOpen Heavens Aerospace LLC · Fort Gratiot, MIS/N 901 N2522BRossman Brian · Valparaiso, INS/N 863 N2522DMiller Stephen · St Louisville, OHS/N 872 N2528EMr Dent Inc · Manheim, PAS/N 869 N2530WHeir Michael R · Clarksville, MDS/N 950 N2532DSherlock William H · Greenbrae, CABuilt 1989 · S/N 868 N2532MNolan John R · Colorado Springs, COS/N 897 N2535ESale Reported · Griffin, GASale reportedBuilt 1989 · S/N 876 N25SWMicro Mechanical LLC · Port Orange, FLS/N 360 N260TBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1996 · S/N 1729 N26TBTinsley Sidney Glenn · Tolulca Lake, CAS/N 486B N275TBDownwind LLC · Olathe, KSBuilt 1991 · S/N 1159 N2800XAffordable Aircraft & Components LLC · Manorville, NYS/N 1104 N2803AOmeara Dennis · Wheat Ridge, COS/N 1036 N28079Abadir Peter · South River, NJS/N 1140 N2808WParker David G · Sedona, AZS/N 1083 N2809ENorth Marin Air LLC · Petaluma, CAS/N 1141 N2812VKennison Daniel J · Las Vegas, NVS/N 1084

Back to AD 87-12-09 R1