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.

N44276Mid Ga Aviation LLC · Perry, GABuilt 1974 · S/N 28-7405232 N4427ARhinehart Daniel · Placentia, CABuilt 1956 · S/N 22-3756 N4427JVaughn John P · Louisville, KYBuilt 1967 · S/N 28-22829 N4427RRedwood Aviation Group LLC · Santa Rosa, CABuilt 1974 · S/N 17263173 N44285Chisolm Joe B · Marble Falls, TXBuilt 1975 · S/N 28-7525255 N4428JJohnson Clyde L · Live Oak, FLS/N 28-22830 N4428PSilver Creek Glider Club · New Douglas, ILBuilt 1964 · S/N 25-2719 N4428RCantrell Boyd T III · Ocala, FLBuilt 1979 · S/N 18201029 N4428TGauvin Daniel G · Newport, VTBuilt 1972 · S/N 28R-7235047 N4428XLeopold Nathan · Fond Du Lac, WIBuilt 1975 · S/N 28R-7635040 N4428YCherry Hill Aviation Inc · Freetown, INS/N 25-4053 N4428ZRegistered aircraftBuilt 1968 · S/N 18-8766 N44290Fly With US LLC · Cantonment, FLBuilt 1974 · S/N 28-7415614 N44295Caribbean Aviation Lc · Miami, FLBuilt 1974 · S/N 32-7440149 N4429APrillwitz Nolan D · Appleton, WIBuilt 1956 · S/N 22-3758 N4429PRegistration Pending · Kenai, AKRegistration pendingBuilt 1960 · S/N 23-1945 N4429QDyberg Mike DBA · Mount Vernon, WABuilt 1973 · S/N 17261708 N4429RMacoupin Flyers Inc · Hettick, ILBuilt 1974 · S/N 17263174 N4429XPearls Pilot LLC · Jefferson City, MOBuilt 1975 · S/N 32-7640021 N4429YBlackstone Aircraft LLC · Hartselle, ALS/N 25-4055 N4429ZAerial Crop Care Co · Hebron, NDBuilt 1968 · S/N 18-8767 N442AAbrams Gary L · Tucson, AZS/N 1809079 N442AHFerrante Aviation Inc · Vandergrift, PABuilt 2004 · S/N 10356 N442APThree Mayhoods LLC · Bonita Springs, FLS/N 61-0267-103 N442BBMcdougall Michael D · Caldwell, IDS/N RV4-1442 N442BNParker Helicopter LLC · Watsonville, CABuilt 2005 · S/N 10642 N442BSNext Level Capital LLC · Spring, TXBuilt 2019 · S/N 71669 N442CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881131 N442CMAnderson Charles M Jr · Snohomish, WABuilt 2010 · S/N 1824 N442CPEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2003 · S/N 10137 N442DBRegistered aircraftBuilt 2002 · S/N R636 N442DCMurray Jeffrey H · Saranac Lake, NYBuilt 2000 · S/N 001 N442DEGlad Air I LLC · Cuyahoga Falls, OHBuilt 2004 · S/N 10279 N442DMYoung Lawrence N · Poplar Grove, ARBuilt 2001 · S/N 2001 N442DRChanging Horizons LLC · Helena, MTS/N 10428 N442DZValiair Limited Company Trustee · Casper, WYBuilt 2004 · S/N T20608453 N442ED&S Aviation LLC · Yakima, WABuilt 1982 · S/N 32R-8213042 N442FAJackson Paul Douglas · Victoria, VAS/N 0708 N442HBAirborne LLC · Wilmington, DEBuilt 1975 · S/N 17265246 N442HCHigh Country Helicopters LLC · Sisters, ORS/N 11017 N442HGGeorgia Aviation Authority · Eastman, GABuilt 2001 · S/N 4496056 N442HHSouthern Utah University · Cedar City, UTBuilt 2003 · S/N 10156 N442JEConcho Aviation LLC · Sterling City, TXBuilt 2004 · S/N 10250 N442JMStarr County Helicopter Services LLC · Mcallen, TXBuilt 2006 · S/N 11125 N442KCAlaska Angel Aviation LLC · Anchorage, AKBuilt 2003 · S/N 003 N442KLLedwith Kenneth E · Lincoln, CABuilt 2009 · S/N 442 N442KPUtah State University · Logan, UTBuilt 2005 · S/N 10862 N442LCKnudtson Kirk · Kasson, MNBuilt 1978 · S/N 28-7890455 N442MDMagill Zane · Castell, TXBuilt 2007 · S/N 1678 N442MLOrlowski Micheal A · Gold Hill, NCBuilt 1966 · S/N 978

Back to AD 87-10-06 R1