Skip to content

Registered aircraft · 22,416

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.

N8122ZCrosswinds Flying Club Inc · Bloomington, ILBuilt 1979 · S/N 28-8011033 N8123CTurlock Fruit Company Inc · Turlock, CABuilt 1979 · S/N 32R-8013014 N8123WHoke Todd D · Hilton Head Island, SCBuilt 1979 · S/N 28-8011034 N8123XKrempp Andrew D · Tarpon Springs, FLBuilt 1979 · S/N 28-8011035 N8124ADakota 7 LLC · Kirkwood, MOBuilt 1979 · S/N 28-8011036 N8124JBulluck Martha C · Apex, NCBuilt 1979 · S/N 28-8011037 N8124MMulcahy Patrick D · Hollister, CABuilt 1979 · S/N 28-8011038 N8124QMn Badger Aviation LLC · Rochester, MNBuilt 1979 · S/N 28-8011039 N8124SBauso Kenneth · Marfa, TXBuilt 1979 · S/N 28-8011040 N81250Sanchez Paul K · Boca Raton, FLFirst renewal noticeBuilt 1979 · S/N 28-8016147 N8125ANt-Cfp LLC · Baltimore, MDBuilt 1979 · S/N 28-8011041 N8125DBas Part Sales LLC · Greeley, COBuilt 1979 · S/N 32R-8029014 N8125WLynch Ronald · Carson City, NVBuilt 1965 · S/N 28-2233 N8125YGlass Jody L · Indianapolis, INBuilt 1979 · S/N 28-8016146 N81260Trusty Archer LLC · Ann Arbor, MIBuilt 1979 · S/N 28-8090155 N8126MWest Hawaii Wingers Incorporated · Kailua Kona, HIBuilt 1979 · S/N 28-8016149 N8126XB2fh Ltd · Allentown, NJBuilt 1979 · S/N 28-8090154 N8127HSpradley Nicholas Scott · Northport, ALBuilt 1979 · S/N 28-8011042 N8127KAntler Aviation And Wildlife Service LLC · Wasilla, AKBuilt 1979 · S/N 32-7940268 N8127ZCrawford Oil Co Inc · Hayti, MOBuilt 1979 · S/N 32R-8029017 N8128BMcguinnis Joseph G · Scottsdale, AZS/N 32R-8029018 N8128WSilver Wings Legacy LLC · Weatherford, TXBuilt 1965 · S/N 28-2238 N8128XSimmons Kenton L · Van Alstyne, TXBuilt 1979 · S/N 28-8016153 N8129HAdventure Bound LLC · Saint Paul, NEBuilt 1980 · S/N 32R-8013054 N8129JFunk Wendell L · Lancaster, PABuilt 1982 · S/N 28-8290093 N8129MAviation Consulting Expertise LLC · Fairfax Station, VABuilt 1982 · S/N 28-8290094 N812ATHaverlah Dennis W · Cedar Park, TXS/N 28-7716211 N812BEHubbell Aero LLC · Fairfax, VABuilt 1999 · S/N 3257115 N812DJDelaware Air LLC · Dover, DEBuilt 1980 · S/N 32-8106010 N812DKTranscendent Enterprises Inc DBA · Pine Grove, CABuilt 2005 · S/N 3257397 N812JSAmsden Max L · Hazen, NDBuilt 1963 · S/N 28-10004 N812MFj Aviation LLC · Texarkana, TXBuilt 2000 · S/N 32-57162 N812NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881046 N812WMApopka Aero Club LLC · Winter Garden, FLS/N 32-7740076 N81305Wadsworth Robert M · Wellesley, MABuilt 1979 · S/N 32-7940270 N8130WAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1965 · S/N 28-2240 N8130XBuck Company LLC · Saint Louis, MOBuilt 1980 · S/N 28-8011045 N8130YDrummond James D · Oshkosh, WIBuilt 1979 · S/N 28-8011046 N8131RPaphos Airways LLC · Farmingdale, NYBuilt 1979 · S/N 28-8016158 N8131WGaudette Philip C · Woodstock, CTS/N 28-8016159 N8131XC&W Leasing · Cedar Rapids, IAS/N 28-8016160 N81321Treacy Richard K · North Massapequa, NYBuilt 1982 · S/N 28-8216113 N81327Roman Maritza Torres · Toa Alta, PRBuilt 1980 · S/N 28-8016164 N8132BOptisure Risk Partners LLC · Manchester, NHBuilt 1979 · S/N 28-8090164 N8132RTwo Brothers Acquisitions LLC DBA · Perris, CAS/N 28-8090166 N8132WGore Robert E Jr · Aiken, SCBuilt 1965 · S/N 28-2243 N8133CCarter Marl · Coburg, ORBuilt 1975 · S/N 28-7690104 N8133ELane Community College · Eugene, ORBuilt 1980 · S/N 28-8016167 N8133JWarrior Aviation LLC · Stanford, KYBuilt 1979 · S/N 28-8016170 N8133SWoodard David · San Diego, CABuilt 1979 · S/N 32-7940271

Back to AD 87-08-08 R3