Skip to content

Registered aircraft · 54,015

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-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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.

N66628Wichmann Gregory Scott · Las Vegas, NVBuilt 1974 · S/N 15076166 N66629Schelhorn Timothy · Nampa, IDBuilt 1978 · S/N 18052951 N6662EMalsby Julius C IV · Bend, ORBuilt 1959 · S/N 56162 N66635Blue River Aviation LLC · Palmer, AKBuilt 1974 · S/N 15076170 N66636November Sierra Aviation LLC · Oneill, NES/N 15076171 N66637Drake Aerial Enterprises LLC DBA · Genoa, OHFirst renewal noticeBuilt 1974 · S/N 15076172 N66639Central Ohio Soaring Assoc Inc · Marion, OHBuilt 1974 · S/N 15076174 N6663FMaltby Michael D · Angier, NCBuilt 1966 · S/N 15063263 N6663TKess Frederic R · Pembine, WIBuilt 1960 · S/N 15059063 N66643Parrott Chad D · Paris, TXBuilt 1978 · S/N 18052952 N66649Miller Tobin D · Palmer, AKBuilt 1974 · S/N 15076182 N6664ASeifert Kerry A · Chugiak, AKBuilt 1956 · S/N 28764 N6664FRogan Thomas R · Munster, INBuilt 1966 · S/N 15063264 N6664TFinnin John A Jr · West Chester, PABuilt 1960 · S/N 15059064 N66652Johnston Craig E · Beach Haven, NJBuilt 1974 · S/N 15076184 N66654Integrated Workforce Solutions Inc · Sacramento, CAFirst renewal noticeBuilt 1974 · S/N 15076186 N66659Devries Douglas · Sparks, NVBuilt 1974 · S/N 15076190 N6665AHolmes James A · Apache Junction, AZS/N 28765 N6665GPurdue Aviation LLC · West Lafayette, INBuilt 1979 · S/N 17273612 N6666ERegistration Pending · Phoenix, AZRegistration pendingBuilt 1959 · S/N 56166 N6666FRibeiro Eugenio P · Fall River, MABuilt 1966 · S/N 15063266 N6667EGunter Wayne E · Talkeetna, AKBuilt 1959 · S/N 56167 N6667NSmith William F · Hindsville, ARBuilt 1978 · S/N 21063141 N66683Gusler Gregory L · Halifax, PABuilt 1974 · S/N 15076206 N66687Ruhe Sales LLC · Leipsic, OHBuilt 1974 · S/N 15076210 N6668ADay Patrick K · Ellensburg, WABuilt 1956 · S/N 28768 N6668TKiley Melanie B · Loudon, NHBuilt 1960 · S/N 15059068 N6668XHocus Holdings LLC · Carrollton, OHBuilt 1961 · S/N 21057668 N66691Maroney Lorraine J · Anchorage, AKBuilt 1978 · S/N 18052954 N66695Moore Jack L · Belfast, MEBuilt 1974 · S/N 15076217 N6669BConstantia Group LLC · Green Cove Springs, FLBuilt 1978 · S/N 21062814 N666BSSmith Bob · Grapevine, TXS/N 18051179 N666ESSharkey Kenneth J · Haverford, PAS/N 21062120 N666JBCopenhaver Tracy K · Anthony, KSBuilt 1973 · S/N 18801427 N666JGGronemeyer Jens · Deland, FLBuilt 1981 · S/N P210-00657 N666JRUhl James Gustav · Ft Mckavett, TXBuilt 1966 · S/N 18257841 N666JVWalter Jack N · Meadville, PABuilt 1972 · S/N 17260737 N666MGGragg Mervyn C · East Wenatchee, WAS/N 15073977 N666MHBenson Shawn E · Rock Hill, SCBuilt 1975 · S/N 17266101 N666MMLawson Robert W · Tacoma, WABuilt 1971 · S/N 17701633 N666RBOlam Holdings LLC · Honolulu, HIS/N 17700051 N666RJNewitt David C · Oakland, CABuilt 1976 · S/N 177RG0902 N666RMBrown Conrad · Beaverton, ORBuilt 1975 · S/N 18263853 N666SBBredin Robert R · Pacific Palisades, CABuilt 1980 · S/N 18503994 N666WPHamilton Stuart E · Covington, GABuilt 1979 · S/N 18266914 N66700Red Barn Aircraft LLC · Highland, WIBuilt 1974 · S/N 15076218 N66704Sale Reported · Le GosierSale reported, pending cancellationBuilt 1974 · S/N 15076221 N66707Tarr Sheryl Lynn · Spokane, WABuilt 1974 · S/N 15076224 N66708Liberty University Inc · Lynchburg, VABuilt 1974 · S/N 15076225 N66709Smith Micheline Diane · St George, UTBuilt 1974 · S/N 15076226

Back to AD 87-20-03 R2