Skip to content

Registered aircraft · 22,432

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.

N15862Butler Michael W · Sacramento, CABuilt 1972 · S/N 28R-7335098 N15868Mogan & White Inc · New York, NYBuilt 1972 · S/N 28-7325182 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 N1588JLampe Mark E · Minnetonka, MNBuilt 1967 · S/N 28-23997 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 N15895Ksgj Aircraft LLC · Saint Augustine, FLBuilt 1972 · S/N 32-7340072 N158CCRegistration Pending · Visalia, CARegistration pendingBuilt 1977 · S/N 28R-7737081 N158NDSkyborne Airline Academy Inc · Vero Beach, FLBuilt 1998 · S/N 2842030 N158PTPilot Training Center LLC · Miami, FLBuilt 1989 · S/N 2841150 N15901Harbor Aviation LLC · Wilmington, DEBuilt 1972 · S/N 28-7310073 N15909Downes Pamela M · Chino Hills, CABuilt 1972 · S/N 28R-7335104 N1590JTidwell Kevin C · Kennesaw, GABuilt 1967 · S/N 28-23999 N1590XLanders Stephen F · Riverview, FLBuilt 1975 · S/N 28R-7535344 N15914Studt Joseph Floyd · Rockvale, COBuilt 1972 · S/N 28-7325197 N15916Marianas Air Transfer Inc · Tinian, MPBuilt 1972 · S/N 28-7325199 N15918Ramseier Peter A · Imperial Beach, CAS/N 28-7305185 N15919Tikhomirov Anton · Ashland, MABuilt 1973 · S/N 28R-7335106 N1591JWingard Edward J · Powell, OHBuilt 1968 · S/N 28-24001 N1591XTask Aviation LLC · Vancouver, WABuilt 1975 · S/N 32-7540180 N159274dw Interests LLC · Longview, TXBuilt 1973 · S/N 28-7325202 N15928Bussell Matthew W · Reno, NVBuilt 1973 · S/N 28-7305187 N15929Cs Flying Ltd · Grafton, OHBuilt 1972 · S/N 28-7305188 N1592XN2211z LLC · Lantana, FLBuilt 1975 · S/N 28-7515427 N15930Rogers Aviation LLC · Florence, SCBuilt 1973 · S/N 28-7305189 N15931Smitty 172 LLC · Rockford, MIS/N 28R-7335108 N15933Flaps Inc · White Bear Lake, MNBuilt 1973 · S/N 28-7325203 N15935Stahl Dennis E · Wood Dale, ILBuilt 1973 · S/N 28-7305190 N15936Brown Norman C · Kewanee, ILS/N 28-7305191 N15939Ray H Gregg · Nashville, GABuilt 1973 · S/N 32-7300021 N1593JRindeikis Bron · Sugar Grove, ILS/N 28-24003 N1593XVaniscak Greg A · Fort Collins, COBuilt 1975 · S/N 28R-7535345 N15943Edgerton Eddie Lee · Midwest City, OKBuilt 1973 · S/N 28-7325208 N15944Habit Samuel P · Kokomo, INBuilt 1973 · S/N 28-7305193 N15945Newton Flying Club Inc · Collinsville, MSBuilt 1972 · S/N 28-7305194 N15946Leading Edge Inc · Cottonwood Heights, UTBuilt 1973 · S/N 28-7305195 N1594XPiper Flyers LLC · Zionsville, INBuilt 1975 · S/N 32R-7680004 N15955Air Wings Enterprise LLC · Roca, NEBuilt 1973 · S/N 28-7325210 N15956Hanson Mark E · Griffin, GABuilt 1973 · S/N 28-7305196 N15957Jones John E Jr · Metter, GABuilt 1973 · S/N 28-7305197 N15961Kings Wings · Jupiter, FLBuilt 1973 · S/N 32-7300022 N15962Romero Jason Nathanial · Broken Arrow, OKS/N 28-7325213 N15966Acosta Aaron · El Paso, TXBuilt 1973 · S/N 28-7325214

Back to AD 87-08-08 R3