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.

N8332YShepard Jeffrey · Roanoke, TXS/N 28R-8131075 N83334Davis Bryan Wesley · Earlysville, VABuilt 1981 · S/N 28-8111050 N8333CKasper Kirsten V · Saint James, NYBuilt 1981 · S/N 32-8106041 N8333HN8333h LLC · Saint Cloud, MNBuilt 1981 · S/N 32R-8129038 N8333TRas Aviation LLC · Elyria, OHBuilt 1981 · S/N 28-8116146 N8333WKeeble Robert H Sr · Loudon, TNBuilt 1965 · S/N 28-2514 N83345Whytes Inc · Coconut Creek, FLBuilt 1981 · S/N 28-8116153 N8334NN8334n LLC · Louisa, VABuilt 1980 · S/N 32-8106029 N8334PCanta Alain Ongkeko · Northridge, CABuilt 1981 · S/N 28-8116149 N8334WGhenciu Petre I · Homer Glen, ILBuilt 1981 · S/N 28-8116150 N8334YOncore Aviation LLC · Rochester, NYBuilt 1981 · S/N 28-8116151 N8334ZUfly Vi LLC · St Thomas, VIBuilt 1981 · S/N 28-8116152 N8335WHiatt Ronald G · Forestburgh, NYBuilt 1965 · S/N 28-2516 N8335XKenyon Travis · Phoenix, AZBuilt 1982 · S/N 28R-8331013 N83364Rhoads Eric S · Costa Mesa, CABuilt 1982 · S/N 28-8390035 N8336GGolden Age N8336g LLC · Norwalk, IABuilt 1981 · S/N 28-8190167 N8336HNeel Aviation LLC · Lakeland, FLBuilt 1981 · S/N 28-8190168 N8336RSmith Gerald A Trustee · Bow, NHBuilt 1966 · S/N 28-22209 N8336WJd Aviation LLC · Omaha, TXBuilt 1965 · S/N 28-2518 N8337APn4 Aviation Holdings LLC · Bishop, CABuilt 1981 · S/N 28-8111051 N8337CStahel Zazell L · Kiana, AKBuilt 1976 · S/N 32R-7680101 N8337HRegistered aircraftBuilt 1981 · S/N 32-8106042 N8338CBean Eric J · Canton, NCBuilt 1976 · S/N 28-7625103 N8338DPlant Galen M · Crown Point, INBuilt 1981 · S/N 28-8116156 N8338RMarshall Rodney V · Riverton, UTBuilt 1966 · S/N 28-22211 N8338WL A S LLC · Fort Leavenworth, KSBuilt 1965 · S/N 28-2520 N8339CEberle Michael Thomas · Plato, MOBuilt 1975 · S/N 28-7615089 N8339DLd Flight LLC · Houston, TXBuilt 1982 · S/N 28-8316030 N8339RGonzalez Karina · Bloomfield, NJFirst renewal noticeBuilt 1966 · S/N 28-22213 N8339WYoung Stanley K · Edmond, OKBuilt 1965 · S/N 28-2522 N8339XSeaview Aviation LLC · Pembroke Pines, FLBuilt 1981 · S/N 32-8124012 N8339ZLetendre Brian Paul · Troy, MOBuilt 1981 · S/N 32-8124013 N833GSHogan John A · Florence, SCBuilt 1971 · S/N 32-7200010 N833NDUnd Aerospace Foundation · Grand Forks, NDS/N 2881292 N833TBEuro 2000 Inc · Merritt Island, FLBuilt 2002 · S/N 2842149 N833WTN833wt LLC · Lake City, FLBuilt 1969 · S/N 28-26090 N83400Harry Robinson Pontiac Buick DBA · Fort Smith, ARS/N 32R-8129069 N8340RJohnson Darrell Thomas IV · Yemassee, SCBuilt 1966 · S/N 28-22214 N8340WFasbender Brady T · Menomonie, WIBuilt 1965 · S/N 28-2523 N83416Offutt Air Force Base Aero Club · Offutt Afb, NEBuilt 1981 · S/N 28-8116160 N8341ADavidson Air LLC · Hemet, CAS/N 28-8390021 N8341HDbc Aviation LLC · Charlotte, NCBuilt 1981 · S/N 32R-8129047 N8341RMartin Dennis R · Lake Placid, FLBuilt 1966 · S/N 28-22215 N8342CBennett Donald B · Birmingham, ALBuilt 1976 · S/N 28R-7635149 N8342HBartolf Michael Joseph · Williamston, SCBuilt 1981 · S/N 28-8116162 N8342NHansen Derek J · Lehi, UTBuilt 1981 · S/N 28-8190171 N8342RCaleb Cooper 2 LLC · Pinellas Park, FLBuilt 1966 · S/N 28-22216 N8342YThompson Kevan R · Penn Yan, NYBuilt 1981 · S/N 28-8190179 N8343BGc Aviation Services LLC · Springboro, OHS/N 32-8124014 N8343HG&C Leasing Inc · Lunenburg, MABuilt 1981 · S/N 32R-8113046

Back to AD 87-08-08 R3