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.

N8162RNoyes Daniel Ernest · Burton, MIBuilt 1980 · S/N 28-8090252 N8162WBistline Fredrick G · Page, AZBuilt 1965 · S/N 28-2279 N8163EThistle Richard E · Fresno, CAS/N 28-8011066 N8163SDilouis Andre J · West Deptford, NJBuilt 1980 · S/N 28-8016277 N8163THeuschele Michael C · Foristell, MOBuilt 1980 · S/N 28-8090253 N8163WAkins Daryl D · Creighton, MOBuilt 1965 · S/N 28-2280 N8163YBachman David R · Chisago City, MNBuilt 1980 · S/N 28-8090254 N81645Chalmers Aviation Services LLC · Owasso, OKS/N 28R-8031071 N8164WAerovia LLC · Austin, TXS/N 28-2281 N8164ZOrtiz Celestino Jose G · Fort Worth, TXBuilt 1980 · S/N 28R-8018047 N8165CChandelle Flying Club · Austin, TXBuilt 1975 · S/N 28-7615080 N8165GSkychaser LLC · Green Brook, NJS/N 28-8216127 N8165JLloyd J Cleaver D O LLC · Kirksville, MOBuilt 1980 · S/N 32-8024010 N8165NDettore Thomas J · Shavertown, PABuilt 1980 · S/N 32R-8013066 N8165RLord David A DBA · Mackay, IDFirst renewal noticeBuilt 1980 · S/N 32R-8029063 N81669Esteves Anthony · Hillsborough, NJBuilt 1980 · S/N 28-8016215 N8166BBouchard Dustin · Springfield, MOS/N 28-8216129 N81673Kcn Aero Club · Overland Park, KSBuilt 1980 · S/N 28-8090258 N8167DBurch Robert S · Tyler, TXBuilt 1980 · S/N 32R-8029049 N8167FEximious Flying Club Inc · Ferndale, MIBuilt 1983 · S/N 28-8390073 N8167NAlley Bryan T · Pensacola, FLBuilt 1969 · S/N 28-25363 N8167WDestination Flyer LLC · Memphis, TNBuilt 1965 · S/N 28-2285 N8168ZLittle Doing Big Inc · Templeton, CABuilt 1980 · S/N 28R-8031074 N816983000 Summer Street LLC · Brookfield, CTBuilt 1980 · S/N 32R-8013069 N8169NMiller Marcus Wayne · Oklahoma City, OKBuilt 1968 · S/N 28-25365 N8169ZHarper Hugh Holdings LLC · Alvarado, TXBuilt 1980 · S/N 32-8024012 N816GMAtd Pilot Training LLC · Kansas City, MOBuilt 1976 · S/N 28-7615219 N816PKSix Papa Kilo Aviation LLC · Savannah, GAS/N 28-8090334 N816WAFredericks Ruth · Miami, FLS/N 28-7525173 N816WBNorthern Aggregate Inc · Bemidji, MNBuilt 1980 · S/N 32-8006015 N816YPB&D Air Solutions LLC · Austin, TXBuilt 1978 · S/N 32R-7885267 N8170FAlfonso Peter J · Jamestown, RIBuilt 1980 · S/N 32R-8013071 N8170NFalter George H III · Baltimore, MDBuilt 1968 · S/N 28-25366 N8170SSkywagons.Com LLC · Placerville, CAS/N 32R-8029067 N8170YRaven Aeronautics Ltd · Monument, COBuilt 1980 · S/N 32R-8029069 N81713Brown Matthew · Spokane, WABuilt 1980 · S/N 28-8016290 N81715Registration Pending · Hanford, CARegistration pendingS/N 28-8016291 N8171NOndrovic Rick · Belton, SCBuilt 1968 · S/N 28-25367 N8171WAnderson Christopher J · Ogden, UTBuilt 1965 · S/N 28-2291 N8171YFaith Works Aviation LLC · Glenmoore, PABuilt 1980 · S/N 28-8016284 N81726Johnson Micaiah P · Tucson, AZBuilt 1980 · S/N 28R-8031075 N8172NBeasley Michael Jeffrey · Dothan, ALS/N 28-8090261 N8172PWison Keene · Abbeville, GABuilt 1981 · S/N 32R-8129028 N8172QFrost Aviation Services Inc · Las Cruces, NMBuilt 1980 · S/N 28-8090263 N8172WMile High Advertising LLC · Dover, DEBuilt 1965 · S/N 28-2294 N8172ZAverka Steven D · Sutton, MABuilt 1980 · S/N 28-8090264 N8173HMcmahon Mary G · Winchester, CABuilt 1980 · S/N 28-8011097 N8173NJones Roy F · Benson, AZBuilt 1968 · S/N 28-25369 N8173PLao Investments LLC · Meeker, COBuilt 1980 · S/N 32-8024015 N8173WRoadrunner Flight School LLC · Farmington, NMS/N 28-2295

Back to AD 87-08-08 R3