Skip to content

Registered aircraft · 58

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:85-22-08-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:85-22-08-R2') 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:85-22-08-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:85-22-08-R2')
  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:85-22-08-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:85-22-08-R2')
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.

N126KLAircraft Fidelity Corp Trustee · Dover, DEBuilt 1984 · S/N 096 N155ERAir Medical Services LLC · Denver, NCBuilt 1984 · S/N 55-098 N155SJLopez Fabio · Denver, NCBuilt 1984 · S/N 102 N16LJLear Holding Corp · Wilmington, DEBuilt 1986 · S/N 126 N18EVE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1983 · S/N 077 N1VGE D Santos & Associates LLC Trustee · Wilmington, DES/N 121 N20CRWestern Air International Corp · Fort Lauderdale, FLBuilt 1983 · S/N 097 N211GSInternational Air Services Inc Trustee · Carson City, NVBuilt 1982 · S/N 021 N238AXFabio Lopez · Denver, NCS/N 030 N255LVN255rv Aviation Corp Inc · Middletown, DES/N 004 N255RVSolomon Mark Trustee · Wilmington, DEBuilt 1983 · S/N 095 N257SJN257sj Aviation Corp · Middletown, DEBuilt 1985 · S/N 55-118 N270JPLopez Fabio A · Denver, NCS/N 078 N277ALAti Jet Inc · El Paso, TXBuilt 1984 · S/N 104 N285CTCf Aviation Trust LLC Trustee · Wilmington, DEBuilt 1983 · S/N 085 N285DHRoyal Air Freight Inc · Waterford, MIBuilt 1982 · S/N 026 N329TJForsythe Aviation LLC · Point Lookout, MOS/N 120 N355RMLopez Fabio A · Denver, NCBuilt 1982 · S/N 033 N355UALopez Fabio A · Denver, NCBuilt 1984 · S/N 114 N385RCTms Global Investments Inc · Naples, FLBuilt 1984 · S/N 117 N429FCLopez Fabio · Denver, NCBuilt 1983 · S/N 091 N505EHSolomon Mark Trustee · Wilmington, DEBuilt 1982 · S/N 067 N515CYPacwest Aerodyne LLC · Tualatin, ORS/N 028 N531PPerair Corp · Manhasset Hills, NYS/N 93 N53HJVentura Aviation Inc · Farmingdale, NYBuilt 1982 · S/N 037 N54NWAti Jet Sales West LLC · El Paso, TXBuilt 1982 · S/N 054 N550TCContinental Jet LLC · Vero Beach, FLS/N 034 N551MFDodson International Parts Inc · Rantoul, KSS/N 15 N551RARoyal Air Freight Inc · Waterford, MIBuilt 1982 · S/N 076 N558RABas Part Sales LLC · Greeley, COBuilt 1983 · S/N 086 N558RJWorldwide Option LLC · Lewes, DES/N 012 N55FJN55fj LLC · El Cajon, CABuilt 1983 · S/N 089 N56HSInternational Jet Aviation Services · Centennial, COBuilt 1982 · S/N 072 N590TCLear Holding Corp · Wilmington, DEBuilt 1983 · S/N 082 N5XRAviacion Del Oeste Inc · Mayaguez, PRBuilt 1982 · S/N 063 N61SJByrum Lyle Trustee · Roswell, NMBuilt 1983 · S/N 081 N628EKKauffman Land & Development LLC · Fort Lupton, COBuilt 1982 · S/N 071 N62LJN62lj LLC · Fort Lauderdale, FLBuilt 1982 · S/N 056 N657DJCastiron 5 LLC · Wilmington, DEBuilt 1983 · S/N 094 N69VHKolob Canyons Air Services Inc · Wilmington, DEBuilt 1982 · S/N 062 N700SRMd Jet Aviation Services Inc · Wilmington, DEBuilt 1983 · S/N 079 N715MGRichard L Richards Pa Trustee · Coral Gables, FLS/N 003 N717AMLopez Fabio · Denver, NCBuilt 1984 · S/N 100 N717EBAmigos Al Dia Pr LLC · Carolina, PRBuilt 1981 · S/N 016 N717HBTms Global Investments Inc · Naples, FLBuilt 1982 · S/N 066 N723CCAgave International LLC · Wellington, FLS/N 036 N762MG1mg LLC · Fort Wayne, INBuilt 1982 · S/N 035 N803JGCf Aviation Trust LLC Trustee · Wilmington, DES/N 115 N805PCRoyal Air Freight Inc · Waterford, MIS/N 55-018 N824CCLg & Gs Holdings II LLC · Middletown, DEBuilt 1982 · S/N 55-024

Back to AD 85-22-08 R2