Skip to content

Registered aircraft · 26,232

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.

N60940O Lazy L Ranch & Farm · Satanta, KSBuilt 1969 · S/N 15070681 N60941Mayo Wilburt E Jr · Landers, CABuilt 1969 · S/N 15070682 N60943Walters William L · Boise, IDBuilt 1969 · S/N 15070684 N60944Brecht Deen R · Golden Valley, NDBuilt 1969 · S/N 15070685 N6094AKtkv Flyers Inc · Tomahawk, WIBuilt 1956 · S/N 28694 N6094JHyten Mark B · Zionsville, INBuilt 1973 · S/N A1500394 N6094KPcs Aviation LLC · Louisa, VAFirst renewal noticeBuilt 1975 · S/N 15077522 N60950Sattizahn William M · Fredericksburg, PABuilt 1969 · S/N 15070690 N60959Cruz Abdiel Ayala · Ocala, FLBuilt 1969 · S/N 15070697 N6095JWaterman David K · Temple City, CABuilt 1973 · S/N A1500395 N6095RWilbanks James R · Clayton, GABuilt 1965 · S/N 17253764 N6095VCessna 170b LLC · Eagle River, AKS/N 20724 N60962Barnstormers Inc · Bemidji, MNBuilt 1969 · S/N 15070699 N60967Salyer Robert D · Nashville, TNS/N 15070701 N60968Nelson Gary A · Grand Marais, MNBuilt 1969 · S/N 15070702 N6096GPilot Pros Inc · Miami, FLBuilt 1969 · S/N 15071596 N60970Airfrank Inc · Hackensack, NJBuilt 1969 · S/N 15070704 N60976Fly Low Aviation LLC · Smithville, MSS/N 15070709 N60977Conrad James · Cape Girardeau, MOBuilt 2003 · S/N 008 N6097RBravo Charlie One LLC · Redkey, INBuilt 1965 · S/N 17253766 N60982Taylor Gregory William II · Angels Camp, CABuilt 1969 · S/N 15070714 N60983Jpm Aircraft Leasing LLC · Wilmington, DES/N 15070715 N60988Cluck Charles W · Spring, TXBuilt 1969 · S/N 15070718 N6098JHall David K · State College, PABuilt 1973 · S/N A150-0397 N60995Replogle Thomas J · Redondo Beach, CAFirst renewal noticeBuilt 1969 · S/N 15070721 N6099AAnderson Timothy D · Mountain Iron, MNBuilt 1956 · S/N 28699 N6099HBens Aerial Spraying LLC · Turtle Lake, NDBuilt 1946 · S/N 19257 N6099JVincent David R · Hartley, TXBuilt 1973 · S/N A1500399 N609WCReimler Dan T · Rozet, WYBuilt 2008 · S/N 001 N60DHSmith Bryan · Moss Point, MSBuilt 2000 · S/N 546 N60HZDamschroder Rex A · Fremont, OHS/N 1389 N60JWalrath Michael J · Indian Lake, NYS/N 4-1256 N60JSTilghman Charles R Jr · Van Alstyne, TXBuilt 1970 · S/N JS-2 N60NGMcpherson Joseph Miller · Benson, AZBuilt 2008 · S/N AL-1141 N60PEMagliacano Matthew J · Cleveland, MOFirst renewal noticeBuilt 1952 · S/N 20799 N60TWVeverka Merle G · Frederick, COBuilt 1983 · S/N TW-1 N60VKBennett Anthony · Bradenton, FLBuilt 2011 · S/N DH48 N61001Monroe Perry M · Woodinville, WABuilt 1969 · S/N 15070724 N61009Jansky Michael J · Hallettsville, TXBuilt 1969 · S/N 15070730 N6100GEvent Tech Services LLC · Quarryville, PABuilt 1969 · S/N 15071600 N61010Hall Scotty · Cheraw, SCBuilt 1969 · S/N 15070731 N61019Goodwin William J · Charlotte C H, VAS/N 15070738 N6101EScherer Dean W · Saint Joseph, MNS/N 46201 N61020Houk Sean R · Lyons, OHBuilt 1969 · S/N 15070739 N61026Johnson David A · Dover, OHBuilt 1969 · S/N 15070744 N61028Berendes Jay R · Shullsburg, WIBuilt 1969 · S/N 15070746 N61031Pacific Aircraft Services · Aurora, ORBuilt 1969 · S/N 15070749 N61033Dame John D · Omaha, NEBuilt 1969 · S/N 15070751 N61038Bartholomew Howard R Jr · Mechanicsburg, PABuilt 1969 · S/N 15070755 N6103ERadloff Adam E · Delaware, OHBuilt 1958 · S/N 46203

Back to AD 94-05-05 R1