Registered aircraft · 4,787

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:75-09-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-09-13') 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:75-09-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-09-13')
  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:75-09-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-09-13')
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.

N123AMC W Myers Holdings LLC · Anthony, NMBuilt 1973 · S/N 340-0245 N123AZN123az LLC · Las Vegas, NVS/N EA-498 N123BCBlue River Baron 58 LLC · Malcolm, NEBuilt 1977 · S/N TK-41 N123BTYingling Consultation LLC · Wilmington, DEBuilt 1973 · S/N 421B0414 N123CEBas Part Sales LLC · Greeley, COS/N 21061054 N123DDCenturion 123 LLC · Glenwood Springs, COBuilt 1974 · S/N 21060627 N123DEGearhart John D · Arlington, WAS/N 35926 N123MCNelson Isaac · Saint Croix Falls, WIS/N 21063578 N123TBTango Bravo LLC · Wilmington, DEBuilt 1979 · S/N 340A0795 N123TDVinanam Aviation LLC · Cupertino, CABuilt 1977 · S/N 340A0307 N123VRLewis Edward M · Mesquite, NVS/N 210-59891 N12434Aviation S And S LLC · Miami, FLBuilt 1983 · S/N 414A1002 N1245AAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1984 · S/N 414A1201 N124CCWeaks Taylor Madison · Houma, LABuilt 1984 · S/N 46-8408036 N124DRLeventis Phil P · Sumter, SCBuilt 1973 · S/N 340-0219 N124MDKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1981 · S/N TJ374 N124TMUniversal Aviation LLC · Decatur, ARS/N 421C-0898 N124WC3-B Farms Inc · Pinetown, NCBuilt 1973 · S/N 421B0484 N124WHHillcrest Aircraft Co Inc · Lewiston, IDBuilt 1979 · S/N U20605355 N1252GInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 414-0809 N125ARJuliet Kilo Air 1 LLC · Paradise Valley, AZBuilt 1980 · S/N EA-169 N125BMBaron Transporation Services LLC · Destrehan, LAFirst renewal noticeBuilt 1978 · S/N 21062926 N125CPLinscott Jeffrey R · Boring, ORBuilt 1972 · S/N 340-0093 N125LLDykstra Darren · Pacific Grove, CABuilt 1982 · S/N TJ-417 N125TCYoung Jeremy · Portland, ORBuilt 1975 · S/N TJ-3 N126BTSecure Storage Solutions LLC · Thomaston, GABuilt 1977 · S/N 4140909 N126TKLoftis Chris · Fort Worth, TXBuilt 1980 · S/N TK-126 N1276VNew Horizon Aviation Inc · Warwick, RIBuilt 1984 · S/N T30300262 N1289UKavak Air Inc · Middletown, DEBuilt 1982 · S/N 21064682 N128BRNautilus Aviation LLC · Yadkinville, NCBuilt 1979 · S/N 414A0231 N128MCDawson Aircraft Inc · Clinton, ARBuilt 1984 · S/N 340A1808 N129ABPhilly Express LLC · Wilmington, DEBuilt 1994 · S/N EA-561 N129ELTrooien-Smith Construction LLC · Seeley Lake, MTBuilt 1978 · S/N U20604374 N12DUWoodtick Summit Aviation LLC · Redmond, ORBuilt 1979 · S/N U20605202 N12EVDaedalus LLC · Little Rock, ARBuilt 1985 · S/N 46-8508065 N12KNJane Air LLC · Kalamazoo, MIBuilt 1968 · S/N 421-0130 N12PFRucker Gary R · Kingman, AZBuilt 1977 · S/N 21062401 N12RJDesert Air Ambulance Inc · Blythe, CABuilt 1977 · S/N 421C0306 N12SBSilvano Sal · La Grange, KYBuilt 1979 · S/N 340A0911 N12WTMtzb Corp · New York, NYBuilt 1974 · S/N 421B0829 N130HLFair Winds Aviation LLC · Shreveport, LABuilt 1979 · S/N 414A0322 N130RACarter Distribution Lc · Salt Lake City, UTBuilt 1976 · S/N 340A0040 N130RCWilliams Brian G · Las Cruces, NMBuilt 1983 · S/N P21000822 N131TTCharlie Kilo Enterprises Inc · Melbourne, FLBuilt 1979 · S/N U20605010 N132RXJ + D Aviation Services LLC · Centerville, MAS/N 402C0609 N1331MRegistered aircraftBuilt 1985 · S/N 21064903 N1338UJstream Lc · Sheridan, WYBuilt 1965 · S/N 411-0105 N133LBlair Byron · Ajo, AZBuilt 1952 · S/N D-3300 N133PCGilco Distributors · Santa Rosa, CABuilt 1976 · S/N 340A0093 N1346LAtwell Air LLC · Grundy, VABuilt 1977 · S/N 33701838

Back to AD 75-09-13