Registered aircraft · 4,243

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:89-24-01-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:89-24-01-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:89-24-01-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:89-24-01-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:89-24-01-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:89-24-01-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.

N124DRLeventis Phil P · Sumter, SCBuilt 1973 · S/N 340-0219 N124MDKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1981 · S/N TJ374 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, LABuilt 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 N12PFRucker Gary R · Kingman, AZBuilt 1977 · S/N 21062401 N12SBSilvano Sal · La Grange, KYBuilt 1979 · S/N 340A0911 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 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 N134GGGibson Gordon S Trustee · Pacific Palisades, CABuilt 1981 · S/N 340A1202 N134MDAa Aviation LLC · Lewes, DES/N TJ-449 N134RDDevere Albert R · Warrenton, VABuilt 1955 · S/N BG-11 N134RRRussell Jon D · Calabasas, CABuilt 1957 · S/N BG-340 N1351RN1351r Inc · Middletown, DEBuilt 1979 · S/N EA-21 N135RWOneal Eric T · Geneva, FLBuilt 1981 · S/N TJ-351 N135USJohn Hale · Temple, TXBuilt 1987 · S/N 46-08078 N136BEHeavy D Airways LLC · Fountain Hills, AZBuilt 1992 · S/N EA-541 N136CMTriple C Inc · Carlsbad, NMS/N EA-437 N136DDMason Daniel Racing LLC · Porterville, CABuilt 1981 · S/N EA-212 N136TCWeis Samuel K · Madera, CABuilt 1979 · S/N EA-15 N1379GTwo Golf Tango LLC · Albuquerque, NMBuilt 1976 · S/N 340A0078 N1383GKuper Carl J II · Dalhart, TXBuilt 1976 · S/N 340A0082 N1385V303 Tango Charlie LLC · Newark, DEBuilt 1984 · S/N T30300266 N138PBSouth Delta Aviation Inc · West Helena, ARBuilt 1980 · S/N TJ-273 N138PLCpg Air LLC · Skaneateles, NYBuilt 1986 · S/N TJ-482 N138TLHarvest International Ministries Inc · Texarkana, ARBuilt 1981 · S/N TJ-362 N1396AEsser J Randolph Trustee · Birmingham, ALBuilt 1969 · S/N D-9012 N139BBTrejo Nahomy · Socorro, TXBuilt 1979 · S/N 21063712 N13KSNolt Ivan · Mount Solon, VABuilt 1974 · S/N 21060202

Back to AD 89-24-01 R1