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.

N3614RKrautschun Bart · Spearfish, SDS/N 28-5710 N3614XPanther Enterprises LLC · Fort Myers, FLS/N 5090 N36150Bas Part Sales LLC · Greeley, COBuilt 1978 · S/N 32R-7885166 N3615MRenfro Michael W · Bethel, AKBuilt 1947 · S/N 12-2461 N3615NWalker Eric L · Southlake, TXBuilt 1967 · S/N 680012 N3615QPlane Safe Aircraft Maintenance Inc · Waukesha, WIS/N MB-237 N36167James Brett · Louisburg, NCBuilt 1978 · S/N 28-7890497 N3616NDe Masters Jasper · Bakersfield, CABuilt 1967 · S/N 680013 N3616PKidd Myles · Machesney Park, ILBuilt 1955 · S/N 22-3344 N36173Schuster Darin D · New Castle, DEBuilt 1973 · S/N 546-73 N36176Otte Duane P · Plainfield, INBuilt 1973 · S/N 101-73 N36178California Flyers Training Solutions LLC · Sun City, CABuilt 1973 · S/N 383-73 N3617PPhilpott Gary D · Camden, SCBuilt 1956 · S/N 22-3723 N36185Stapleton Rita · Gallipolis, OHBuilt 1978 · S/N 32R-7885169 N36187Swaz Aviation LLC · Mesa, AZBuilt 1978 · S/N 28-7816619 N3618CHoshor Matthew David · Wetumpka, ALBuilt 1978 · S/N R18200278 N3618MRatcliffe Andrew M · Jerome, AZBuilt 1978 · S/N 28-7890319 N3618NYoung Donald Colin · West Plains, MOBuilt 1967 · S/N 680014 N3618XHildenbrand Casey E · Circleville, OHBuilt 1968 · S/N 5095 N36194Cripps Alan Stephen · Hoover, ALBuilt 1978 · S/N 32R-7885171 N3619KKirk Trevor A · Ponderay, IDBuilt 1967 · S/N 28-23656 N3619NChiques Aero Corporation · Lancaster, PABuilt 1967 · S/N 680015 N3619RBachelor Cabin Flying Services Inc · Kokomo, INBuilt 1969 · S/N 28-5714 N3619XNeeds Shaely M · Pueblo, COS/N 5096 N361ACBond Robert E · Kingsville, MOBuilt 1974 · S/N 497-75 N361AKAronson Kenneth I Trustee · Truckee, CABuilt 2016 · S/N 91935 N361CPBarr Air Patrol LLC · Mesquite, TXBuilt 2001 · S/N 172S8840 N361ESGrady Paul D · Reno, NVBuilt 1997 · S/N 17280011 N361ETW Fairfield Aviation Inc · Caldwell, KSS/N 437 N361FSBlue Yonder Aviation Inc · Rochester, NYBuilt 1997 · S/N 23039C N361MEN361me LLC · Blanding, UTBuilt 1978 · S/N 28-7890361 N361MKNorth Star Aviation Inc · Mankato, MNBuilt 2022 · S/N 2881588 N361NDUniversity Of North Dakota · Grand Forks, NDBuilt 2024 · S/N 2881827 N361PPecoraro Phil I · Reno, NVBuilt 1999 · S/N 187 N361RPRocha Aviation LLC · Prescott Valley, AZBuilt 1973 · S/N 32-7440046 N361SSmith Steve A · Buckley, WABuilt 2005 · S/N 617320363FB N361VSchwartz Kenneth · Afton, MNBuilt 1997 · S/N AACA/692 N361WA32 Poco LLC · Dover, DEBuilt 1999 · S/N 3257121 N361WEOn Da Way Exotic Car Rentals LLC · Fort Lauderdale, FLS/N 28-23827 N361ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881644 N362Andi 362 LLC · Duncan, SCBuilt 1975 · S/N 28-7690096 N36201Bmw Lance Inc · Gardner, MABuilt 1978 · S/N 32R-7887027 N36202Red Rock Aircraft Leasing LLC · Hurricane, UTBuilt 1978 · S/N 32R-7887028 N36209Indian Hills Community College · Ottumwa, IABuilt 1978 · S/N 28-7816622 N3620CSnohomish Flying Service Inc · Snohomish, WABuilt 1978 · S/N R18200279 N3620NMooney N3620n LLC · Chesterfield, MOBuilt 1967 · S/N 680016 N3620RBarker Richard · Temecula, CABuilt 1970 · S/N 28-5716 N3620WSemler Jason M · Cambridge, MNBuilt 1966 · S/N 32-521 N3620XEvans David J · Parker, COBuilt 1968 · S/N 5097 N36213N36213 Aircraft Ownership LLC · The Woodlands, TXBuilt 1975 · S/N 17702240

Back to AD 87-10-06 R1