Skip to content

Registered aircraft · 22,413

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N55272Nienhuis Alvin Dale II · Brooksville, FLBuilt 1973 · S/N 28-7305348 N55273Jcb Aircraft Sales & Leasing Inc · Belle Mead, NJBuilt 1973 · S/N 28-7305349 N55275Bas Part Sales LLC · Greeley, COBuilt 1973 · S/N 28R-7335209 N55278Hackman Daniel W · Wimauma, FLBuilt 1973 · S/N 32-7300035 N5527FFarnie Christopher J · Jacksonville, FLBuilt 1968 · S/N 28-24868 N5527JBeachside Transports LLC · Hampstead, NCBuilt 1967 · S/N 32-987 N55284Winters Daniel K · Pennsburg, PABuilt 1973 · S/N 28-7325359 N55287Prairie Winds Aviation LLC · Overland Park, KSBuilt 1973 · S/N 28R-7335210 N55289May Richard J · Fallbrook, CABuilt 1973 · S/N 32-7300036 N5529FKeiner Larry E · Drums, PABuilt 1968 · S/N 28-24871 N5529JFarsighted Aviation LLC · Connersville, INBuilt 1968 · S/N 32-990 N5529UStoll Travis · El Dorado Springs, MOBuilt 1969 · S/N 28-26245 N5529WHarvey Gregory D Sr · Greenbush, MEBuilt 1962 · S/N 28-623 N552JAAv8r Flying Club LLC · Warsaw, INBuilt 1967 · S/N 32-40147 N552PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842089 N55301Registered aircraftBuilt 1973 · S/N 28-7325361 N55302Coastl Air Inc · Groton, CTBuilt 1973 · S/N 28-7325362 N55303Cullum Phillip R Jr · San Tan Valley, AZBuilt 1973 · S/N 28-7325363 N55304Brittle Aviation LLC · Chapel Hill, NCBuilt 1973 · S/N 28-7305353 N55305Berry Mitchel R · Chatfield, MNBuilt 1973 · S/N 28-7305354 N55306R & R Flying LLC · Miami, FLBuilt 1973 · S/N 28R-7335212 N55308Charger 308 LLC · Hollis, OKBuilt 1973 · S/N 28-7310126 N5530JSellers Justin Kennedy · North Augusta, SCBuilt 1967 · S/N 32-992 N5530WHobgood Sidney · Klamath Falls, ORBuilt 1962 · S/N 28-621 N55310Monarch M Miller · Cloverport, KYBuilt 1973 · S/N 28-7325364 N55311Aeras Transport LLC · Lewes, DEBuilt 1973 · S/N 28-7305355 N55313Dunning Mark · Chino Hills, CABuilt 1973 · S/N 28-7305357 N55315Norman Eric Lee · Hilton Head Island, SCBuilt 1973 · S/N 28-7305359 N55317Schwader Aviation LLC · Saint Joseph, MOBuilt 1973 · S/N 28R-7335214 N55319Guckin Michael E · The Villages, FLBuilt 1973 · S/N 28R-7335215 N5531FSchmidt David D · Atlantic Mine, MIBuilt 1968 · S/N 28-24874 N55327Grise Paul R · Hopkinsville, KYBuilt 1973 · S/N 28-7305362 N5532JRegistration Pending · Trinity, FLRegistration pendingBuilt 1967 · S/N 32-979 N5532UGorman Jeremy J · Chapman, KSBuilt 1969 · S/N 28-26249 N55330Eaw Aviation LLC · Middletown, MDBuilt 1973 · S/N 28R-7335218 N55331Scholl Oil & Transportation Company · Holyoke, COBuilt 1973 · S/N 28-7310128 N55338Pt Arts LLC · Grand Rapids, MIBuilt 1973 · S/N 28-7325370 N5533FCopenhaver Ralph L · Brady, TXBuilt 1968 · S/N 28-24876 N55340Air55 LLC · Charleston, WVBuilt 1973 · S/N 28-7305363 N55345Arrow Flite LLC · Chino Hills, CABuilt 1973 · S/N 28R-7335220 N55347Roze Scott L · Port Orange, FLBuilt 1973 · S/N 28-7310129 N55359Uribe Roberto · Houston, TXBuilt 1973 · S/N 28R-7335222 N5535FTrent Donald R · Rustburg, VABuilt 1968 · S/N 28-24934 N5535JBreadner Robert A · OntarioNon-citizen corporation, flight hours not reportedBuilt 1967 · S/N 32-998 N55360Ball Duke Allen · Drakesville, IABuilt 1973 · S/N 32-7340113 N55364Cremel Roberto J · Trumbull, CTS/N 28-7325384 N5536FArnt James R Jr · Worthington, MNBuilt 1968 · S/N 28-24935 N5536JHanna Patricia A · Davis Junction, ILS/N 32-999 N5536UPittman Discover Flight LLC · Oshkosh, WIBuilt 1969 · S/N 28-26257 N5536WSchilke Kenneth · Imperial, NES/N 28-626

Back to AD 87-08-08 R3