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.

N2123MPapadopoulos Dimitris Alexander · Dallas, TXBuilt 1979 · S/N 28R-7918034 N2123TMy Way Aviation LLC · Weston, FLS/N 28R-7135066 N2124FHesseltine Robert J · Grand Terrace, CABuilt 1978 · S/N 28-7916173 N2124JDomas Jeffrey P · Mankato, MNBuilt 1978 · S/N 28-7916201 N2125TBasquit Kenneth · Pittsburgh, PAS/N 28R-7135068 N2125VGallagher Stephen · Delray Beach, FLBuilt 1977 · S/N 32R-7780431 N2127ALockhart Michael Orian Jr · Altus, OKBuilt 1978 · S/N 32R-7985002 N2127GKneeshaw Donald J · Gilbert, AZBuilt 1978 · S/N 32R-7987079 N2127KLee Bruce W · Strasburg, COBuilt 1978 · S/N 28R-7931021 N2127PDerbenwick Gary F · Colorado Springs, COBuilt 1979 · S/N 28-7990291 N2127RCohen Blanche F · Aurora, COBuilt 1969 · S/N 28-5465 N2127TGeiger Glenn M · Cincinnati, OHBuilt 1971 · S/N 28R-7135070 N21288Cunningham Campers Inc DBA · Clarksville, INBuilt 1978 · S/N 28-7990040 N2129AY Naught Aviation LLC · Madill, OKBuilt 1978 · S/N 32R-7987006 N2129GNorth Central Marketing Inc · Cranston, RIBuilt 1978 · S/N 32R-7987080 N2129TSebesta Arthur J II · Winchester, KYBuilt 1971 · S/N 28R-7135072 N2129ZWelch Peter C · Carmel, NYBuilt 1979 · S/N 28-7911152 N212BMLeaseair LLC · Wilmington, DES/N 28R-7235136 N212DXPiper Aircraft Inc · Vero Beach, FLS/N 28010105 N212FMooney Daniel V · Malvern, PABuilt 1971 · S/N 28-7205015 N212TVParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020070 N2130CDurrett Bentley K · Rusk, TXS/N 28-7916132 N2130JEarly Bird Aviation LLC · Rillito, AZBuilt 1978 · S/N 28-7990214 N2130KQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N 28R-7931023 N2130RAscend Aviation LLC · Ira, MIBuilt 1969 · S/N 28-5466 N2130TWasson Ronald L · Colleyville, TXBuilt 1971 · S/N 28R-7135073 N2130UZadora-Przylecki Karol · Sammamish, WABuilt 1979 · S/N 28R-7931093 N21313Foster Peter · University Park, TXBuilt 1978 · S/N 32R-7887200 N2131JAllen Harvey · Elfrida, AZBuilt 1978 · S/N 28-7990215 N2131TMullin Thomas F III · Birmingham, ALBuilt 1971 · S/N 28R-7135111 N21323A2t Guys Aviation LLC · Williamston, MIBuilt 1978 · S/N 28-7916033 N2132JHolley William M · Rock Port, MOBuilt 1978 · S/N 28-7990216 N2132TMatejcek Lina M · Owatonna, MNBuilt 1971 · S/N 28-7125448 N2133ASchnack Kenneth L · Crescent, IAS/N 32R-7987007 N2133JHoosier Aviation LLC · Terre Haute, INBuilt 1978 · S/N 28-7990217 N2134DRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1978 · S/N 28-7916144 N2134ERice Larry Anthony Trustee · Yucaipa, CABuilt 1978 · S/N 28-7990180 N2134JMcmahan Michael Anthony · Dunwoody, GABuilt 1978 · S/N 28-7990218 N2134NPainter Christopher R · Castle Rock, COBuilt 1979 · S/N 28R-7931048 N2134RVanek Peter · Sedona, AZBuilt 1969 · S/N 28-5467 N2134TBartow Municipal Airport Development Authority · Bartow, FLBuilt 1971 · S/N 28R7135142 N21352Lane Shannon L · Hopkinsville, KYBuilt 1978 · S/N 32R-7885252 N21356Elite Financial Management Inc · Dallas, TXBuilt 1978 · S/N 32R-7887202 N21357Wild Outdoors Oil LLC · Velma, OKBuilt 1978 · S/N 32R-7887203 N2135BMiloud Chadd K · Fort Worth, TXBuilt 1978 · S/N 28-7916110 N2135FMark Alan Bennett · Trinidad, COS/N 28-7990188 N2135TPeter Prince Aviation Center LLC · Milton, FLBuilt 1971 · S/N 28R-7135139 N2136CPope Keith D · Mineral Wells, TXBuilt 1978 · S/N 28-7911022 N2136EInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 28R-7918002 N2136JHanus John E · North Kingstown, RIBuilt 1978 · S/N 28-7990219

Back to AD 87-08-08 R3