Skip to content

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.

N4157EBel Air LLC · Henderson, KYBuilt 1984 · S/N 31P-8414047 N4157HDhf LLC · Valentine, NEBuilt 1993 · S/N 1809069 N4157LMorton John W · Hurricane, UTBuilt 1993 · S/N 1809073 N4157RMckenna Brothers Aircraft LLC · Anchorage, AKBuilt 1993 · S/N 1809076 N4157TRandel Vernon E · Erie, COBuilt 1994 · S/N 1809082 N4157UAeromarine Holdings LLC · Waukesha, WIBuilt 1993 · S/N 1809078 N4157WBoardman Rick · Henderson, NEBuilt 1994 · S/N 1809083 N4157ZReinbold Frederick Karl · Anchorage, AKBuilt 1965 · S/N 18-8339 N41580Eagle Racer LLC · Boca Raton, FLBuilt 1994 · S/N 1809104 N41583Files Barbara E · Hopkinton, MABuilt 1974 · S/N 28-7415282 N41584D Luckie LLC · Kalispell, MTBuilt 2008 · S/N 1897 N41585Bas Part Sales LLC · Greeley, COBuilt 1974 · S/N 28R-7435203 N41587Gary Deborah · Houston, TXBuilt 1994 · S/N 1809105 N4158DBoho LLC · Lewes, DEBuilt 1994 · S/N 1809087 N4158LJm Lavore Aero Inc · Lakeside, MTBuilt 1994 · S/N 1809100 N4158WButler John P · Hazelhurst, WIBuilt 1994 · S/N 1809102 N4158YAlliance Aircraft Sales Inc · Pierre, SDBuilt 1994 · S/N 1809103 N4158ZSchaetzel Paul Robert · New Meadows, IDBuilt 1965 · S/N 18-8340 N41593Flyin LLC · Hyde Park, UTS/N 28-7415286 N41594Butler John P · Hazelhurst, WIBuilt 1994 · S/N 1809113 N41598Fox Flying Club Inc · Wheaton, ILBuilt 1999 · S/N 2843290 N41599Tiger Helicopters LLC · Baton Rouge, LABuilt 1999 · S/N 4636187 N4159AHauser Associates Inc · Coral Gables, FLBuilt 1994 · S/N 1809106 N4159DBachman Aviation LLC · Independence, IAS/N 1809110 N4159KRegistered aircraftBuilt 1998 · S/N 22015C N4159PSparks Brian E · Monmouth, ORBuilt 1959 · S/N 23-1644 N4159RArmstrong Scott T · Navasota, TXBuilt 1968 · S/N 32-40474 N4159SCrew Marshall D · Spokane, WABuilt 1994 · S/N 1809109 N4159WNorthern Sky Aviation LLC · Howard Lake, MNBuilt 1967 · S/N 32-40231 N4159XHagglund Carl D · Pendleton, ORS/N 341 N4159YBauer Aviation LLC · Reese, MIBuilt 1977 · S/N 23877 N415AMUtah State University · Logan, UTBuilt 2005 · S/N 40.517 N415BHCentral Airlines Inc · Overland Park, KSBuilt 1960 · S/N 500B-918-5 N415CAFly For Fun Aircraft LLC · Baltimore, MDS/N 2843215 N415CCCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1968 · S/N 27-3908 N415CFAlo Fliteline Lc · Waterloo, IABuilt 1975 · S/N 28-7505118 N415ECCreativity Before Capital LLC · Tampa, FLBuilt 2006 · S/N 40415 N415GKCentral Clinton County Flying Club Inc · Jersey Shore, PABuilt 1982 · S/N 28-8290151 N415GSKirkman Robert Nolan · Pilot Mountain, NCBuilt 2004 · S/N 81406 N415HPRichmond George H Jr · Elkhorn, NEBuilt 1963 · S/N 30-181 N415JBBrewer Allen E · Madison, MSBuilt 1999 · S/N 1463 N415JSCarey James A · St Charles, ILBuilt 2016 · S/N 40874 N415KGSky Safety Inc · San Antonio, TXBuilt 2005 · S/N 40.483 N415LLost Pines Tours LLC · Bastrop, TXBuilt 1977 · S/N 32-7740073 N415LEStadelman Edwin F · East Falmouth, MABuilt 1999 · S/N 20608042 N415MEngelien Wendell · Port Orange, FLBuilt 2025 · S/N 24456 N415MDHammychan Industries LLC · Glendale, AZBuilt 1967 · S/N 27-3492 N415MRKropp Matthew M · North Creek, NYBuilt 2014 · S/N 001 N415MSNextgen Flight Academy Inc · Riverside, CABuilt 1978 · S/N 28-7816430 N415PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843448

Back to AD 87-10-06 R1