Skip to content

Registered aircraft · 72,001

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.

N157TASpace Coast Aircraft Co · Meritt Island, FLBuilt 1998 · S/N 2842029 N157TBPerrin James F · Bancroft, WIBuilt 1997 · S/N 1389 N157WAUnited States Air Force - Owner · Hanscom Afb, MABuilt 2019 · S/N 2881157 N157WMYale Companies LLC DBA · Indianapolis, INBuilt 2002 · S/N 4496157 N157YRosenberg Gordon W Trustee · San Ardo, CABuilt 1967 · S/N 1 N157ZZRegistered aircraftS/N 18280402 N15800Somd Aircraft Rentals And Instruction LLC · Leonardtown, MDBuilt 1972 · S/N 28-7325167 N15802Farias Wellington N · Hollis, NHS/N 28-7305146 N15804Lima Juliet LLC · Pearcy, ARBuilt 1972 · S/N 28-7305150 N15807Timmons Nathan M · Sarepta, LABuilt 1972 · S/N 28-7325168 N15808Dudek Henry · Clinton Township, MIBuilt 1972 · S/N 28-7325169 N1580EBermudez John M · Pembroke Pines, FLBuilt 1978 · S/N 17271051 N1580VPrecision Curbs And Concrete LLC · Shady Cove, ORS/N 17263696 N158124 Bachelors LLC · Chesaning, MIS/N 28-7305152 N15814Alderson Collin · North Bend, NEBuilt 1972 · S/N 28R-7335094 N15819Brewer Les · Magna, UTS/N 28-7325170 N1581JDarling Steven M · Decatur, INS/N 28-23989 N15822Keys Daniel A · Irvine, CABuilt 1972 · S/N 28-7325172 N15824Sale Reported · Angwin, CASale reportedBuilt 1972 · S/N 28-7305156 N15825Jem Machine Inc · Grangeville, IDBuilt 1972 · S/N 28-7305157 N1582XInnovative Aviation LLC · Indiana, PAS/N 28R-7535340 N15832Mickschl Bradley J · Avon, INBuilt 1972 · S/N 28R-7335093 N15839Phoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7350100 N1583XK&T Lawn & Landscape Inc · Newport News, VABuilt 1975 · S/N 32-7540179 N15842Reynolds Larry J · Rhome, TXBuilt 1972 · S/N 28-7325177 N1584EDurbin William E · Parkersburg, IABuilt 1978 · S/N 17271052 N1584JLake Kenneth M · Manchester, MOBuilt 1967 · S/N 28-23993 N15850Aviation East Inc · Mount Pleasant, SCBuilt 1972 · S/N 28-7305164 N15851Eakle Ivan · Sacramento, CABuilt 1972 · S/N 28-7325190 N15858T T T Inc · Georgetown, PABuilt 1972 · S/N 28-7325180 N1585JAnderson Aviation LLC · Eatonville, WABuilt 1967 · S/N 28-23994 N15860Baker Stephen J · Surprise, AZBuilt 1972 · S/N 28-7305165 N15861Registration Pending · Traverse City, MIRegistration pending, pending cancellationBuilt 1972 · S/N 28-7305167 N15862Butler Michael W · Sacramento, CABuilt 1972 · S/N 28R-7335098 N15868Mogan & White Inc · New York, NYBuilt 1972 · S/N 28-7325182 N1586JLuczak Thomas W · Agoura Hills, CABuilt 1976 · S/N 13016 N15871Atlaspar Aviation Group LLC · Lenoir City, TNBuilt 1972 · S/N 28-7305168 N15873Miller Robert B · Davenport, FLBuilt 1972 · S/N 28-7305169 N15875Cjb Investments22 LLC · Holly Hill, FLBuilt 1972 · S/N 28-7305171 N15881Ruhnke James · Houston, TXBuilt 1972 · S/N 28-7305173 N15882Ellwood David A · Cambridge, OHBuilt 1972 · S/N 28-7305174 N15884Fredrickson Ronald C · Woodlake, CABuilt 1972 · S/N 28-7310072 N15888Quimbayo Ligia I · Homestead, FLBuilt 1972 · S/N 28-7325189 N1588EGeaux Giddum 1 LLC · Brandon, MSBuilt 1978 · S/N 17271054 N1588JLampe Mark E · Minnetonka, MNBuilt 1967 · S/N 28-23997 N1588RRed Earth Trips Inc · Wilmington, DEBuilt 1975 · S/N AA5B-0088 N1588VC-140 Company LLC · Milton, FLBuilt 1974 · S/N 17263683 N1588XMilligan Reid · Catawba, NCBuilt 1975 · S/N 28-7510087 N15892Registered aircraftBuilt 1972 · S/N 28-7305177 N15894Dunlap Dalton · Port Neches, TXBuilt 1972 · S/N 28R-7335102

Back to AD 87-10-06 R1