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.

N4207HGage Duane · Princeton, IDBuilt 1948 · S/N 14-10 N4207TMisiura Edward Stanley Trustee · Elmhurst, NYBuilt 1971 · S/N 28-7225093 N4207YAnderson John A · Palmer, AKBuilt 1977 · S/N 972-77 N4208RPeh Aviation LLC · Morristown, TNBuilt 1969 · S/N 32-40573 N4208XDeaton Timothy W · Norfork, ARBuilt 1971 · S/N 5208 N4208YScout Towing Company · Omaha, NEBuilt 1977 · S/N 243-77 N42095Cpkb · Summit, NJBuilt 1974 · S/N 17264158 N4209GMhoc LLC · Pensacola, FLBuilt 1968 · S/N 69-16026 N4209HKirby Ronald S · Delta Junction, AKBuilt 1948 · S/N 14-11 N4209PN4209p LLC · Eagle River, WIS/N 23-1702 N4209QLakeland Aviation Of Minocqua Inc · Minocqua, WIBuilt 1971 · S/N 17260109 N4209RLo-Flyer 235 LLC · Boyle, MSBuilt 1969 · S/N 32-40574 N4209XSimmons Scott E · De Queen, ARBuilt 1971 · S/N 5209 N4209ZBy Sky Or By Sea LLC · Kalispell, MTBuilt 1966 · S/N 18-8428 N420ARArakelian Arthur DBA · Worcester, MABuilt 2000 · S/N 3257149 N420CSSugar Lips Aviation LLC · Kalispell, MTBuilt 2005 · S/N 18281650 N420FMcmullen Morrell E · Angleton, TXBuilt 2001 · S/N 3287 N420FPSky Ventures LLC · Flagstaff, AZBuilt 2006 · S/N 40.FC020 N420FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 2004 · S/N 18281494 N420GBOnemanconcrete LLC · Thaxton, VABuilt 2013 · S/N 657-320-402 N420GNNorsworthy Garry Lynn · Grapeland, TXBuilt 1999 · S/N 927 N420HPBraden Health LLC · Greensboro, NCBuilt 2005 · S/N 18281637 N420LKRegistered aircraftBuilt 2024 · S/N 40206 N420LPCross Todd J · Johnstown, COBuilt 2000 · S/N 4028 N420RFritz David W · Kerrville, TXBuilt 1979 · S/N R18200948 N420RMCummiskey Ryan J · Jamesville, NYBuilt 2002 · S/N 2843523 N420TVictor James A · Santa Ynez, CAS/N M-II-375 N420TCBowling Green Flight Center LLC · Bowling Green, OHBuilt 1999 · S/N 2843220 N420URcs Services LLC · California, MDBuilt 1997 · S/N 17280120 N420VHodges Mcneill Jr · Andersonville, GABuilt 2010 · S/N RD 001 N4210JPlamondon Steven J · Lake Leelanau, MIBuilt 1966 · S/N 28-22556 N4210MParagon Air Group · Fort Worth, TXBuilt 1998 · S/N T20608009 N4210QKoehn Jerome D · Fairview, OKBuilt 1971 · S/N 17260110 N4210RWalle Neil M · Klamath Falls, ORBuilt 1969 · S/N 32-40575 N4210ZMccarthy Gary W · Chugiak, AKBuilt 1966 · S/N 18-8429 N42111Blanchfield Christine Lizabeth · Devils Lake, NDBuilt 1974 · S/N 17264159 N42117Sturdivant Marshall J · Ellijay, GABuilt 1974 · S/N 17264160 N4211HRn Roofing LLC · Brandon, MSS/N 24-0662 N4211J11j Inc · Fort Lauderdale, FLBuilt 1966 · S/N 28-22558 N4211QJwmp Air Inc · East Moriches, NYBuilt 1971 · S/N 17260111 N4211RDyson Michael · Duxbury, MABuilt 1969 · S/N 32-40576 N4211XClyde A Russell · Redlands, CABuilt 1971 · S/N 5211 N42126Zrelak Patrick · Apple Valley, CABuilt 1974 · S/N 17264162 N4212AEast West Aviation Club · DuffelS/N 32R-7885198 N4212HG And H Aviation · Louisville, KYBuilt 1978 · S/N 24-0663 N4212RLetkeman Abram · Amarillo, TXBuilt 1969 · S/N 32-40577 N4212TAci Medical Management Inc · San Marcos, CABuilt 1971 · S/N 28-7205099 N4213QFogarty Aviation Inc · Wasilla, AKBuilt 1971 · S/N 17260113 N4213RClear Blue Skies Aviation LLC · Warner Robins, GABuilt 1969 · S/N 32-40578 N4213TMallard Aviation LLC · Manchester, NHBuilt 1971 · S/N 28-7205100

Back to AD 87-10-06 R1