Skip to content

Registered aircraft · 26,231

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:94-05-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:94-05-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:94-05-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:94-05-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:94-05-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:94-05-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.

N4642TDickman Edward A · Melba, IDBuilt 1947 · S/N 11-1438 N4643EScheff David A · Marcell, MNBuilt 1949 · S/N 7CCM-209 N4643HPatrick Matthew · Cincinnati, OHBuilt 1948 · S/N 17-55 N4643MFuhr David L · Wabasso, MNBuilt 1947 · S/N 11-151 N4643XTaylor Aaron B · Leander, KYBuilt 1966 · S/N 15064693 N4645CEasom William J · Thousand Oaks, CAS/N 25589 N4645MSoderquist Jon E · Savage, MNBuilt 1947 · S/N 11-152 N4646EMeffert Lloyd A · Cotter, ARBuilt 1946 · S/N 7AC-2452 N4647CConcolor LLC · Shoreview, MNBuilt 1953 · S/N 25591 N4647LTerrel Mitchell · Alva, OKBuilt 1966 · S/N 17254642 N4648XRipp Patrick L · Mineral Point, WIBuilt 1966 · S/N 15064698 N464SANoyes Daniel W · Oak Point, TXBuilt 1946 · S/N 8973 N4650XBurt Compton Enterprises Inc · Marfa, TXBuilt 1966 · S/N 15064700 N4651Vossman John W · Houston, TXBuilt 1969 · S/N GG-1 N4652ERalston Roger A · Grand Rapids, MNBuilt 1950 · S/N 7EC-3 N4653ERossland David T · Williston, NDBuilt 1950 · S/N 7EC-5 N4654CSafer Jeff S · Eagle River, WIBuilt 1953 · S/N 25598 N4654HWorkman Paul E · Urbana, OHBuilt 1948 · S/N 15-366 N4654VWay Robert L II · Morristown, AZFirst renewal noticeBuilt 1953 · S/N 19630 N4654XMurray Dale W · East Wenatchee, WABuilt 1966 · S/N 15064704 N4655XJp Aero Holdings Inc · Carson City, NVS/N 15064705 N4656CHavener Hunter W · Chittenango, NYS/N 25600 N4656GFoss Jared K · Greenbush, MNBuilt 1957 · S/N 7EC 598 N4656LRegistered aircraftBuilt 1966 · S/N 17254651 N4657CHayden Dale G · Wisconsin Rapids, WIBuilt 1953 · S/N 25601 N4657ENystrom Bay Farm Partnership · Pierre, SDBuilt 1950 · S/N 7EC-7 N4657XVan Buskirk Samuel Victor · Valdez, AKFirst renewal noticeBuilt 1966 · S/N 15064707 N4658ELund Clayton L · Cheboygan, MIBuilt 1950 · S/N 11CC-274 N4658LHarrison Doug A · Yellville, ARS/N 17254653 N4659CBeesley Cattle Company LLC · Port Gibson, MSBuilt 1953 · S/N 25603 N4659EMichigan Tail Draggers LLC · Macomb, MIBuilt 1950 · S/N 7EC-8 N4659LTalcorp Inc · Justin, TXBuilt 1966 · S/N 17254654 N4659SRoss Kaelee N · Dunnellon, FLS/N 1 N465QSchmidt Fred P · Fenton, MOBuilt 1966 · S/N 17255475 N4660EKuhn Marwynne G · Hilltop Lakes, TXBuilt 1950 · S/N 7EC-9 N4660LSitton Wyatt D · Washtucna, WABuilt 1966 · S/N 17254655 N4660TAndersen John N · Kenosha, WIS/N BV-1 N4660XRegistered aircraftS/N 15064710 N4661Traver Larry L · Sturgis, SDBuilt 1971 · S/N 1967 N4661LMccall Thomas A · Glen Saint Mary, FLBuilt 1966 · S/N 17254656 N4661XDresden Leasing LLC · Sheridan, WYS/N 15064711 N4662CPhillips Greg C · Kelseyville, CABuilt 1953 · S/N 25606 N4662LD R Tripp Enterprises LLC · Omaha, NEBuilt 1966 · S/N 17254657 N4663HJestice Valerie · Viola, ARS/N 15-369 N4663LSwanson Daniel · Wasilla, AKBuilt 1966 · S/N 17254658 N4664HMurphy Terrence W III · Belmont, NHBuilt 1948 · S/N 17-69 N4664LThrasher Jody R · Mesquite, TXBuilt 1966 · S/N 17254659 N4666CRegistered aircraftBuilt 1953 · S/N 25610 N4666EWells Kris G · Barron, WIS/N 7EC-14 N4666LBrewster Cynthia R · Friendswood, TXBuilt 1966 · S/N 17254661

Back to AD 94-05-05 R1