Skip to content

Registered aircraft · 22,411

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.

N20PGSteiner Gregory L · Fort Lauderdale, FLBuilt 1966 · S/N 28-22276 N20QCHenderson Stephen L · Carthage, NCBuilt 1977 · S/N 28-7890227 N20RNOlive Aviation LLC · Anchorage, AKBuilt 1977 · S/N 28R-7703125 N20SALc Air Leasing LLC · Treasure Island, FLBuilt 1976 · S/N 28-7690337 N20TACopperstone Fc LLC · Lancaster, PABuilt 2010 · S/N 2843677 N2100AAniakudo Obiesili · Northville, MIS/N 32R-7987002 N2100XSchwind Michael K · Dublin, OHBuilt 1979 · S/N 28-7921008 N21018Vega Aircraft LLC · Arcadia, OKBuilt 1978 · S/N 32R-7887186 N2101FVaughan Bradley C · Truckee, CABuilt 1978 · S/N 32R-7987064 N2101TTraylor John M · Helena, ALBuilt 1971 · S/N 28R-7135045 N21027Noomen Excavating LLC · Currie, MNBuilt 1978 · S/N 32R-7887187 N2102BGillen Diesel Aviation LLC · Dania Beach, FLBuilt 1978 · S/N 32R-7985011 N2102CGreat Northern Aircraft Inc · Griffith, INBuilt 1978 · S/N 28-7916130 N2102RLarosa Vincent · Asbury, NJBuilt 1969 · S/N 28-5461 N2102SJericho Air LLC · Hilton Head Island, SCBuilt 1979 · S/N 32R-7985085 N2102YDotzler Richard L Jr · Harlan, IABuilt 1979 · S/N 28-7911144 N21030Aircraft Management Group Inc · Honolulu, HIBuilt 1978 · S/N 28-7816529 N2103JTaffet Jay · New Orleans, LABuilt 1978 · S/N 28-7911073 N2103MMontgomery William A · El Paso, TXBuilt 1977 · S/N 28R-7837066 N2103XBrandon Capital Group Inc · Leland, MIS/N 32-7940084 N2104NHammond Brian R · Lincoln University, PABuilt 1979 · S/N 28-7990271 N2104TAllison Jack A · Orangevale, CABuilt 1971 · S/N 28R-7135048 N2104UVeracy Aviation LLC · Arlington, VABuilt 1979 · S/N 28-7990327 N2104ZZukauskas Girenas · Naperville, ILBuilt 1979 · S/N 28R-7931153 N21052Registered aircraftN-number assigned, not yet registeredS/N 28-7916023 N2105BNwf Aviation LLC · Defuniak Springs, FLBuilt 1979 · S/N 32R-7987025 N2105THolt Dennis A · Gilbertsville, PABuilt 1971 · S/N 28R-7135051 N2105UPiper Automotive & Marine Service Inc · North Miami, FLBuilt 1979 · S/N 28-7990328 N21065Omni Management LLC · Decatur, ALS/N 28-7990033 N2106CRunde Dean G · Riceville, IAS/N 28-7916131 N2106ZC & E Aviation LLC · Lewes, DEBuilt 1979 · S/N 28R-7931154 N2107DBreslow Arnold M · Dania, FLBuilt 1978 · S/N 28-7916142 N2107EFly Kilo Charlie LLC · New Century, KSBuilt 1978 · S/N 28-7916162 N2107GMerkle Betty Lou · Hanover, ILBuilt 1978 · S/N 28-7911068 N2107VEveritt Fred Jr · Henryville, INBuilt 1979 · S/N 28-7911127 N2108CMetro Aircraft Co · Bloomington, MNBuilt 1978 · S/N 28-7990142 N2108HWise Charles · Bridgewater, MAS/N 28-7911053 N2108VFast And Slow To Go LLC · Dover, DEBuilt 1979 · S/N 28-7911128 N2109Klassen Wendell L · Mountain Lake, MNS/N 28-7425216 N2109NStallings Farms Trucking LLC · Hertford, NCBuilt 1979 · S/N 28-7990274 N2109TCarver Aero LLC · Muscatine, IABuilt 1971 · S/N 28R-7135055 N210EZFaulkison Brian S · Watkins, COBuilt 1978 · S/N 28-7990077 N210KBIanasher LLC · Montgomery, TXS/N 28-7210017 N210SPCooper Mark D · Colchester, CTBuilt 1979 · S/N 28R-7918048 N2110TN2110t LLC · Columbus, OHBuilt 1971 · S/N 28R-7135056 N2110WRegal Aero LLC · Agua Dulce, CABuilt 1979 · S/N 28R-7918078 N2110YFlying Colors Airparts Inc · Leesburg, FLBuilt 1979 · S/N 28-7921011 N21116Prestige Worldwide Aviation LLC · Downers Grove, ILBuilt 1978 · S/N 28-7916025 N2111ARoth David · Corrales, NMBuilt 1978 · S/N 32R-7987004 N2111CKey City Fliers · Maquoketa, IABuilt 1978 · S/N 28-7911021

Back to AD 87-08-08 R3