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.

N8103HAlleghany Flying Club Inc · Hyndman, PABuilt 1979 · S/N 28-8090116 N8103QFlight Time Builders Inc · Memphis, TNBuilt 1979 · S/N 28-8090117 N8103WRegistration Pending · West Linn, ORRegistration pendingS/N 28-2201 N8104CFly Cosah LLC · Kalamazoo, MIS/N 28-7625095 N8104WJejgr LLC · Presho, SDBuilt 1965 · S/N 28-2203 N8104YHawkins Jared · Fostoria, OHBuilt 1979 · S/N 28R-8018013 N81052True North Air LLC · Anchorage, AKBuilt 1982 · S/N 32-8206023 N81053Wernimont Thomas R · Spring Valley, WIS/N 28R-8031010 N8105HBrunelle Marc R · Kennebunk, MES/N 28R-8031004 N8105JOghab LLC · Atlanta, GABuilt 1979 · S/N 28R-8031005 N8105WPrillwitz Robert L · Black River Falls, WIBuilt 1965 · S/N 28-2204 N8105ZInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 28R-8031007 N81067Dakota Wings LLC · Leedey, OKBuilt 1979 · S/N 28-8011012 N8106HSavage Daniel F III · Lynchburg, VABuilt 1979 · S/N 28R-8031012 N8106MWest Houston Aviation LLC · Houston, TXBuilt 1979 · S/N 28-8011006 N8106PPrime Directive LLC · Olympia, WABuilt 1979 · S/N 28-8011007 N8106RHickerson Jess W · Beulah, WYBuilt 1979 · S/N 28-8011009 N8107BFlying 20 Club Inc · Newtown, CTBuilt 1979 · S/N 28-8011013 N8108MBeach Eric S · New Port Richey, FLBuilt 1979 · S/N 28R-8018006 N8108WV4msu LLC · Frankenmuth, MIBuilt 1980 · S/N 32-8024002 N8109DLichtsteiner Patrick H · Shepherdsville, KYBuilt 1979 · S/N 28R-8018014 N8109GCamous Alain · Sunrise, FLS/N 28R-8018015 N8109RHeagy Stephen M · Hillsboro, ORBuilt 1979 · S/N 28R-8018016 N8109WEvans James F Jr · East Hartland, CTBuilt 1965 · S/N 28-2209 N8109ZSener Joseph P · Galena, ILBuilt 1979 · S/N 28-8011014 N810AM5280 Flying Club LLC · Castle Pines, COBuilt 2022 · S/N 2881578 N810DAMjh Aero Inc · Houston, TXBuilt 1978 · S/N 28-7816427 N810KCBlocker Cale · Savannah, GABuilt 1981 · S/N 32R-8129050 N810MATody Mark H Sr · Grand View, WIBuilt 1967 · S/N 28-23846 N810MJCampbell Fred Cox · Monroe, NCBuilt 1974 · S/N 32-7440082 N810NKAims Community College · Greeley, COBuilt 2020 · S/N 2881344 N810UBoard Of Regents Of University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020230 N8110BSt Air Ltd · Cincinnati, OHBuilt 1979 · S/N 28-8011018 N8110CMarcy Jonathan S Trustee · Newberry, SCBuilt 1975 · S/N 28-7615078 N8110FRobinson Ronald G · Ottawa, ILBuilt 1976 · S/N 28-7790234 N8110WJanczura Boguslaw S · Park Ridge, ILBuilt 1965 · S/N 28-2210 N8112CMidili Aldo D · Volcano, CAS/N 28-8016114 N8112JRamsey Douglas Edward · Monument, COBuilt 1979 · S/N 28-8090124 N8112QLongbranch Av8r LLC · Santa Rosa Beach, FLBuilt 1979 · S/N 28-8090125 N8112WTomerlin Danny · Pulaski, TNBuilt 1965 · S/N 28-2214 N81133Rafiq Abrahem · San Diego, CABuilt 1979 · S/N 28-8090133 N8113BCapitol City Flyers Inc · Madison, WIS/N 28-8090128 N8113HT4 Aviation LLC · Nine Mile Falls, WABuilt 1979 · S/N 28-8090129 N8113KSalmon River Assets LLC · The Woodlands, TXBuilt 1979 · S/N 28-8090130 N8113RShenk Steven S · Strasburg, PABuilt 1979 · S/N 28-8090131 N8113WPridmore Joseph P · Columbus, MSBuilt 1965 · S/N 28-2217 N8113XOsage Air Service Inc · Bridgeton, MOBuilt 1979 · S/N 28-8090132 N81149Fly By Knight Inc · Hammond, LABuilt 1982 · S/N 28-8216110 N8114ASummers Spraying Service Inc · Midland, TXBuilt 1979 · S/N 28-8090135 N8114CLauterbach Coleman J · Hagerstown, MDBuilt 1968 · S/N 28R-30818

Back to AD 87-08-08 R3