Skip to content

Registered aircraft · 562

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:82-16-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:82-16-05-R1') 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:82-16-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:82-16-05-R1')
  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:82-16-05-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:82-16-05-R1')
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.

N554KDWestern Air International Co · Pompano Beach, FLBuilt 1979 · S/N 31-7952157 N555FSJacko Josh E · Anchorage, AKBuilt 1978 · S/N 31-7952046 N555GTRegistered aircraftBuilt 1979 · S/N 31-7952148 N555JGLeia Air LLC · Wilmington, DEBuilt 1979 · S/N 31-8012018 N555MFCloud 555 Inc · Wilmington, DEBuilt 1980 · S/N 31-8012068 N565BTGsg Aviation LLC · Fort Lauderdale, FLBuilt 1980 · S/N 31-8052118 N56MHB S Aviation LLC · Stuart, FLBuilt 1979 · S/N 31-7952068 N56MJBishop Ronald Daniel · Port Orange, FLBuilt 1981 · S/N 31-8152108 N56PCValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 31-8052005 N575EHajdukovich Robert M · Fairbanks, AKBuilt 1976 · S/N 31-7652006 N57GPFoncho Corp · San Juan, PRBuilt 1982 · S/N 31-8252043 N596LKcc Aero LLC · Guaynabo, PRBuilt 1977 · S/N 31-7712036 N59752Visionaire Enterprises LLC · Statesville, NCBuilt 1975 · S/N 31-7612010 N59764Warbelows Air Ventures Inc · Fairbanks, AKBuilt 1975 · S/N 31-7652037 N59777Sofisa Airways Corp · Coral Gables, FLBuilt 1976 · S/N 31-7612020 N59809Lou Dell Aviation LLC · Simpsonville, SCBuilt 1976 · S/N 31-7612037 N59826Air Arctic Inc · Fairbanks, AKBuilt 1976 · S/N 31-7652077 N59829Warbelows Air Ventures Inc · Fairbanks, AKBuilt 1976 · S/N 31-7652081 N59848Sanborn Map Co Inc · Colorado Springs, COBuilt 1976 · S/N 31-7612052 N59865Mccorkle Joseph P II · Tyronza, ARBuilt 1976 · S/N 31-7612065 N59867Cooper Keith L · Tabernash, COBuilt 1976 · S/N 31-7612068 N59906Alpha Whiskey 2 LLC · Brandon, MSBuilt 1974 · S/N 31-7552027 N59936Kelly Kent R · Montgomery, ALBuilt 1975 · S/N 31-7512019 N59982Duck L'Ranch LLC DBA · Fort Lauderdale, FLBuilt 1975 · S/N 31-7552071 N59987Wings As Eagles Mission Air Serv Inc · Oshkosh, WIBuilt 1975 · S/N 31-7552081 N599AHAvtran LLC · Clayton, MOBuilt 1984 · S/N 31-8452019 N59FCLamb Farms Inc · Oakfield, NYBuilt 1979 · S/N 31-7952117 N59GYChieftain N59gy LLC · Saint Augustine, FLBuilt 1977 · S/N 31-7852017 N59JCPegasus Air Charter LLC · Hartford, CTBuilt 1979 · S/N 31-7952181 N606JSStar Marianas Aviation School Inc · Tinian, MPS/N 31-7952145 N60AY2701 Ne 27 Court LLC · Hollywood, FLBuilt 1981 · S/N 31-8152051 N60CGSaj Aviation LLC · Reading, PABuilt 1980 · S/N 318052206 N60TAAero Elite LLC · Springfield, MOS/N 31-7552094 N611DPInversiones Flg Inc · Dorado, PRBuilt 1977 · S/N 31-7812040 N614KFGreat Ledge Development Inc · Saint Louis, MOBuilt 1977 · S/N 31-7752136 N6190UCox Paul G · Bryce, UTBuilt 1974 · S/N 31-7401232 N619PREm Concordia Inc · Brooklyn, NYS/N 31-8052061 N61KBPegasus III LLC · Wilmington, DEBuilt 1981 · S/N 31-8152156 N620RMCbs Inc DBA · Bellefontaine, OHS/N 31-7552040 N622AJYonder Corp · Wilmington, DEBuilt 1976 · S/N 31-7612083 N627MADestination Alaska Air Service LLC · Homer, AKBuilt 1975 · S/N 31-7512055 N62869Brown Henry H · Prospect, KYBuilt 1976 · S/N 31-7652145 N62898M & M Aircraft LLC · Cresson, TXS/N 317652157 N62899Sf Health Solutions Inc · Homestead, FLBuilt 1976 · S/N 31-7652122 N628HADigital Mapping Inc · Huntington Beach, CABuilt 1979 · S/N 31-7952085 N62912Gross Charles C III · Mims, FLBuilt 1976 · S/N 31-7652164 N62923Gv Air Inc · Medford, ORBuilt 1976 · S/N 31-7612093 N62992Light & Variable LLC · Arlington, VABuilt 1976 · S/N 31-7712013 N629RMW J Halberstadt Transportation Inc · Hartland, WIBuilt 1980 · S/N 31-8052197 N633D633d LLC · Miami, FLS/N 31-7852098

Back to AD 82-16-05 R1