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.

N7593BCarhart Thomas M · Galesville, WIBuilt 1957 · S/N 7EC620 N7593XMills Laura L · Canton, OHBuilt 1960 · S/N 17248093 N7594TGrimes Arthur D · Zeeland, MIBuilt 1959 · S/N 47194 N7595UClavel Carl R · North Platte, NEBuilt 1975 · S/N 15077761 N7595XDelgado Mario Jr · Baldwin Park, CAS/N 17248095 N7596BRiegelman Mark A · Manitowish Waters, WIBuilt 1957 · S/N 7FC-94 N7596XBurklund Joel · Minneapolis, MNBuilt 1960 · S/N 17248096 N7598TFieldgrove Matt L · Somerton, AZS/N 47198 N7599BRoblee Mark D · Raleigh, NCBuilt 1957 · S/N 7FC-97 N7599XDmac Aircraft LLC · Savannah, GABuilt 1960 · S/N 17248099 N759ESmith Donald H · Lagrange, GABuilt 1946 · S/N 7AC-1974 N75EAero Techniques Inc · Portage, MIBuilt 1966 · S/N 17255365 N75EZDrexler William G · Peyton, COBuilt 1995 · S/N 1667 N75LCBowles Paul S · Danville, VABuilt 2007 · S/N AL-1094 N75MCPorter Michael · Scottsdale, AZBuilt 2016 · S/N 046 N75MDDanielson Mark Allen · Mason, WIBuilt 1991 · S/N 87 N75PJames Marvin L · Scio, ORBuilt 1957 · S/N ST-1 N75RD75rd LLC · Moraine, OHS/N A-93 N75WCCedar Valley Air LLC · Lehi, UTS/N 15076045 N75ZXWilcox Robbie C · Smithville, MOBuilt 2012 · S/N 75-7861 N76000Crabb Ernest P · Fairbanks, AKBuilt 1946 · S/N 10394 N76006Miller Joseph A · Lompoc, CABuilt 1946 · S/N 10400 N76009Gullwing Aviation Holdings LLC · Lewes, DES/N 10403 N7600MTitan Construction LLC · Pinedale, WYBuilt 1959 · S/N 55900 N7600TXin Han Aviation LLC · Atwater, CABuilt 1960 · S/N 47200 N7600XDemurat Bryan F · Casselberry, FLBuilt 1960 · S/N 17248100 N76014Strader Frank L · Walnut, ILS/N 10408 N76017Gilbeau Leslie A · Hobart, INBuilt 1946 · S/N 10411 N76022Grosso Michael F · Charleston, SCBuilt 1946 · S/N 10416 N76025Boehme Larry R · Albany, WIBuilt 1946 · S/N 10419 N76028Registration Pending · Backus, MNRegistration pendingBuilt 1946 · S/N 10422 N7602TColeman David R · Limerick, MEBuilt 1959 · S/N 47202 N7602XBurkett Anthony E · Rock Hill, SCS/N 17248102 N76033Lemna Bradley Wade · Fort Wayne, INBuilt 1946 · S/N 10427 N76039Henrich Joseph E · New Hope, PABuilt 1946 · S/N 10433 N7603TMurphy Brian K · La Crosse, WIFirst renewal noticeS/N 47203 N76040Argo Timothy D · Stewartville, MNBuilt 1946 · S/N 10434 N76043Mcpartland Patrick · Herriman, UTBuilt 1946 · S/N 10437 N76045Gertz David L II · Winston Salem, NCBuilt 1946 · S/N 10439 N76049Oneal Terry C · Pampa, TXBuilt 1946 · S/N 10443 N7604MVaughn David Rex · Spur, TXBuilt 1959 · S/N 55904 N7604TWestern Nebraska Technical College · Scottsbluff, NEBuilt 1960 · S/N 47204 N7604UWings Flight Enterprises Inc · Danville, KYBuilt 1975 · S/N 15077766 N76051Odom James R · Plainview, TXBuilt 1946 · S/N 10445 N76058Flow Edwin E · Orange Park, FLBuilt 1946 · S/N 10452 N7605XCastleberry Robert F · Sanford, NCS/N 17248105 N76060Parker Boston R · Saint Joseph, MOS/N 10454 N76063Wilson Travis W · Beaver Dam, KYBuilt 1946 · S/N 10457 N7606MDellechaie Frank · South Lake Tahoe, CABuilt 1959 · S/N 55906 N7606TFord Edsel W · Mustang, OKBuilt 1959 · S/N 47206

Back to AD 94-05-05 R1