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.

N150CMDunn James W · Otis, MES/N 15066599 N150CQCalarco Richard A · Hillsboro, ORBuilt 1965 · S/N 15061671 N150CVMmdt Aero LLC · Worthington, OHBuilt 1966 · S/N 15065496 N150DBEvans Thomas J · Little Elm, TXBuilt 1972 · S/N 15074052 N150DDFuentes Daniel · Coral Springs, FLBuilt 1973 · S/N 15075327 N150DECopaair Maintenance Services Inc · Indiantown, FLBuilt 1972 · S/N 15073849 N150DFTaildragger Hq LLC · Melrose, FLBuilt 1964 · S/N 15060672 N150DKShipe Jacqueline M · Louisville, TNBuilt 1968 · S/N 15069738 N150DLLedford Joseph Daniel · Cedartown, GAS/N 15075555 N150DPVendetti Michael J · Olney, MDBuilt 1970 · S/N 15072356 N150DSShelbyville Central High School Cte · Shelbyville, TNBuilt 1964 · S/N 15060368 N150DTWatson Matthew L · Liberty, UTFirst renewal noticeBuilt 1962 · S/N 15059671 N150ETjelta Peter A · Sheyenne, NDBuilt 1967 · S/N 15066502 N150EBRegistered aircraftS/N 15072790 N150EGGreene Harry L · Waipahu, HIBuilt 1969 · S/N 15071635 N150EHPouya Hamid · San Jose, CABuilt 1969 · S/N 15070883 N150EMArman Michael P · Oak Hill, FLBuilt 1967 · S/N 15066362 N150EQSmart Aviation Solutions Inc · Lakeland, FLBuilt 1974 · S/N 15076259 N150EWGlazier Matthew S · Presque Isle, MEBuilt 1968 · S/N 15068457 N150FFKelly Paul M · Granite Bay, CABuilt 1975 · S/N 15076716 N150FJSale Reported · Crystal, MNSale reportedBuilt 1969 · S/N 15071001 N150FLBerry Jeffrey Thomas · Clovis, CABuilt 1969 · S/N 15070938 N150FMSanders Steven M · Powell, WYBuilt 1959 · S/N 17183 N150FTLevine Albert E · Bloomfield, CTS/N 15065352 N150GNCarr Greg Wayne · Mccloud, CABuilt 1975 · S/N 15077043 N150GRSoaring For Christ LLC · Big Lake, AKS/N 15066875 N150HWilliams Zachary · Jackson, MIS/N 15063910 N150HARegistration Pending · Albuquerque, NMRegistration pendingBuilt 1969 · S/N A1500100 N150HFRegistration Pending · Garden Grove, CARegistration pendingBuilt 1965 · S/N 15062350 N150HKCarboneau Kyle R · Chugiak, AKS/N 15076953 N150HRFeliciano Carlos A · Adjuntas, PRBuilt 1967 · S/N 15067248 N150HVExperimental Aircraft Association Inc · Oshkosh, WIS/N 15066657 N150JGoode Stephen C · Canton, TXS/N 15072750 N150JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1974 · S/N 15075916 N150JJMedic Choppers LLC · Springdale, ARBuilt 1970 · S/N 15072231 N150JVHorizon Dreams LLC · Homer, GABuilt 1973 · S/N 15075395 N150JWSheely Kevin L · Lima, OHBuilt 1966 · S/N 15065680 N150KBWord James A · Honey Grove, TXS/N 15070723 N150KCPositive Rate Aviation LLC · Plano, TXBuilt 1972 · S/N 15074254 N150KPRegester Stephen J · Roan Mountain, TNBuilt 1966 · S/N 15065795 N150LAEdwards Kellee L · Carson City, NVBuilt 1972 · S/N 15073266 N150LGFredette Michael Richard · Queen Creek, AZBuilt 1963 · S/N 15059958 N150LJL&C Aviation LLC · Trevorton, PABuilt 1971 · S/N 15072865 N150LK92nd West Aviation Inc · Lonoke, ARBuilt 1966 · S/N 15065029 N150LLColtharp Linda A Trustee · Austin, TXBuilt 1975 · S/N 15076617 N150LSTrout David Lee · Lebanon, INS/N 15074694 N150MDRegistered aircraftAssigned, pending cancellationS/N 15078214 N150MHHousley William M · Jasper, ALS/N 15074821 N150MKKuehlmuss Michael · Whately, MABuilt 1965 · S/N 15061488 N150MVSabia Robert V · San Antonio, TXBuilt 1976 · S/N 15078815

Back to AD 94-05-05 R1