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.

N4427LHatter Ronnie A · Newcastle, OKBuilt 1966 · S/N 17254516 N4427UEichmann Sheri L · Paulden, AZBuilt 1964 · S/N 15060427 N4428UAtlanta Sky Signs LLC · Sharpsburg, GAS/N 15060428 N442PGLuedders & Reed Inc · Pawnee City, NEBuilt 1966 · S/N 17254799 N442VWilson Charles W III Trustee · Mckinney, TXBuilt 1991 · S/N 61 N4430HKromer Jack F · Mount Carroll, ILBuilt 1948 · S/N 15-218 N4430LDunn Michael P · Queen Creek, AZS/N 17254519 N44321Flynn David H · Anchorage, AKBuilt 1946 · S/N 10121 N4432UHull Ronald W · Temecula, CABuilt 1964 · S/N 15060432 N4433BAircraft Partner N4433b Dst · BerlinBuilt 1955 · S/N 26777 N4434EHines Thomas J · Amsterdam, NYBuilt 1948 · S/N 7DC-68 N4434HJenkins James L · Lake Stevens, WABuilt 1948 · S/N 15-223 N4435BHarstad Calvin B · Viking, MNS/N 26779 N4435EWindjue Bryan · Jamestown, NDS/N 7DC-69 N4436BHarris Derek A · Marion, TXBuilt 1955 · S/N 26780 N4436LLehman Bradley R · Onsted, MIBuilt 1966 · S/N 17254527 N4437BCaudill Charles D · Fairbanks, AKBuilt 1955 · S/N 26781 N4437LThomas John · Lees Summit, MOBuilt 1966 · S/N 17254528 N44384Thomas William E · La Crosse, WIBuilt 1946 · S/N 10184 N4438LHarvey Jason Kyle · Glendale, AZS/N 17254529 N44404O Bryant Jeffrey A · Fairbanks, AKBuilt 1946 · S/N 10204 N4440ENeeves Aviation And Flying LLC · Sioux Falls, SDBuilt 1948 · S/N 11CC-221 N4441KWeaver Aircraft Co · Carson City, NVBuilt 1966 · S/N 15065397 N4441LKwon Andrew W · Tujunga, CABuilt 1966 · S/N 17254534 N4442FRegistration Pending · Sulphur, LARegistration pendingBuilt 1958 · S/N 46144 N4442LSchoepflin Robert D · Palouse, WABuilt 1966 · S/N 17254535 N4442UBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 15060442 N4443LHenderson Michael Trustee · Whitman, NES/N 17254536 N4443UFratangelo Robert A · Sodus, NYBuilt 1964 · S/N 15060443 N4444HSatina David J · Norton, OHBuilt 1948 · S/N 15-233 N4444VWolfe Randy K · Middle Grove, NYBuilt 1971 · S/N 15072907 N4445BFassett Barry J · Blaine, MNBuilt 1955 · S/N 26789 N44462Registration Pending · Russellville, ARRegistration pendingS/N 10262 N4446BOz Aviation Inc · Wilmington, DEBuilt 1955 · S/N 26790 N4446EGreer James E · Summit Point, WVBuilt 1948 · S/N 7CCM-103 N4446LC And T Aviation Inc · Madera, CAS/N 17254539 N4447UTrenter Ray J · Waynesboro, GAS/N 15060447 N4448BLadegard Ryan P · Wasilla, AKBuilt 1955 · S/N 26792 N4448LPuertolas Pascual G · Cobb, CABuilt 1966 · S/N 17254541 N4449BPatkotak Hugh Gareth Sr · Anchorage, AKBuilt 1955 · S/N 26793 N444AXOverwatch Tools Inc · Chesapeake, VABuilt 2006 · S/N AL-1021 N444GSWhitten Andrew J · Astoria, ORBuilt 1975 · S/N 15077446 N444TF4tf LLC · Missoula, MTBuilt 1959 · S/N 46907 N444TR444 Tr Inc · Van Alstyne, TXBuilt 1967 · S/N 15067661 N444YZBlue Aero Group LLC · Blairstown, NJBuilt 1965 · S/N 17253119 N4450BRiverview Farm · Starbuck, MNBuilt 1955 · S/N 26794 N4450LSouth Side Corp · Cody, NEBuilt 1966 · S/N 17254545 N4450UGrove Keven W · Ankeny, IABuilt 1964 · S/N 15060450 N4451EMock David H III · Burleson, TXS/N 7CCM-105 N44520Kinsler Kenneth Karl · Sand Springs, OKBuilt 1946 · S/N V-17

Back to AD 94-05-05 R1