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.

N7029SWright Flyers LLC · Fayetteville, GABuilt 1967 · S/N 15067729 N7029UBohlke LLC · Kingshill, VIBuilt 1946 · S/N 3404 N7029XMuroc Joint Unified School District · North Edwards, CABuilt 1960 · S/N 15059129 N702MMErrington John W · Painted Post, NYBuilt 2007 · S/N M-I-2178 N702VPCaribbean Air Partners LLC · Winter Garden, FLBuilt 1964 · S/N 17251373 N7030AStuckle Eugene A · Davenport, WABuilt 1956 · S/N 29130 N7030BFalcon Flight LLC · Las Vegas, NVBuilt 2011 · S/N 16200085 N7030FPaul William · Windfall, INBuilt 1966 · S/N 15063630 N7030SAcoba Dylan Anthony · Orangevale, CABuilt 1967 · S/N 15067730 N70311Webb Butch · Moultrie, GAS/N 17288 N7031FVause Paul William III · Burgaw, NCBuilt 2011 · S/N 16200086 N7031LBohlen Thomas R · Ocala, FLBuilt 2011 · S/N 16200087 N7031MClarity Aviation LLC · Anchorage, AKBuilt 1958 · S/N 55331 N7031SBurns Randall A · Rogers, ARBuilt 1967 · S/N 15067731 N7031XKeller Jeffery W · Longview, TXBuilt 1961 · S/N 15059131 N70329Graham Jacob W · Anchorage, AKBuilt 1946 · S/N 17309 N7032ARobinson Michael D · Folkston, GABuilt 1956 · S/N 29132 N7032DFly America Inc · Palo Alto, CABuilt 2011 · S/N 16200089 N7032STamayo Ernest R · Dripping Springs, TXS/N 15067732 N7032XSmith David P · Pacific Palisades, CABuilt 1960 · S/N 15059132 N7033AWalter Aviation LLC · Bradenton, FLS/N 29133 N7033TTimm Alan W · Hettinger, NDS/N 46633 N7033ZCrawford Michael S · Modesto, CABuilt 1946 · S/N 17004 N70355Wharton Brooks A · Abilene, TXS/N 17339 N7035AMcgavock Edward A · Columbus, WIBuilt 1956 · S/N 29135 N7035EMetz Kevin Michael · Richmond, UTBuilt 1960 · S/N 56535 N7036AMachuga James A · Davis, CABuilt 1956 · S/N 29136 N70375Hatbrightfarm LLC · Wilmington, DES/N 17361 N7037HBurr Jerry · Sedro Woolley, WABuilt 1946 · S/N 20282 N7037MEissinger Joshua · Circle, MTBuilt 1958 · S/N 55337 N7037XCloose Brian D · Carlton, MNBuilt 1961 · S/N 15059137 N7038EBrainerd Phillip S · Lake Placid, FLBuilt 1960 · S/N 56538 N7038GRoeder Blaine W · El Prado, NMBuilt 1973 · S/N 15074609 N7038HTrissell Flying Service Inc · Clarksville, TXBuilt 1946 · S/N 20283 N7038XBrown Timothy J · Madison, SDBuilt 1960 · S/N 15059138 N70395Schallip Robert G Jr · Barbeau, MIBuilt 1946 · S/N 17384 N7039ALafferty David W · Harrisburg, ORBuilt 1946 · S/N 18589 N7039FWharam Glen A · Park River, NDBuilt 1966 · S/N 15063639 N7039GWood Donna L · Wisconsin Dells, WIBuilt 1973 · S/N 15074610 N7039MFurdal Lukasz · Hillsborough, NJBuilt 1958 · S/N 55339 N7039XOlson Scott G · New England, NDBuilt 1961 · S/N 15059139 N703CTHymes Eric Edward · Auburn, GAS/N C0003 N703VPCaribbean Air Partners LLC · Winter Garden, FLBuilt 1963 · S/N 17250823 N703VVBowers Airplanes LLC · Chesterfield, VABuilt 1946 · S/N 3230 N7040FVtf LLC · Winter Haven, FLBuilt 1966 · S/N 15063640 N7040KRowley David B · Lockport, ILBuilt 1989 · S/N 00077 N7040MHood Shawn D · Weatherford, TXBuilt 1958 · S/N 55340 N7040TLesko Shannon Lt · Loves Park, ILBuilt 1959 · S/N 46640 N70414Thomas Charles · Jackson, MIBuilt 1946 · S/N 17405 N70417Sevearance Joshua T · Palatka, FLBuilt 1946 · S/N 17411

Back to AD 94-05-05 R1