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.

N134MDAa Aviation LLC · Lewes, DES/N TJ-449 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 N13HLFreedom 421b LLC · Jacksonville, FLBuilt 1975 · S/N 421B0927 N13KSNolt Ivan · Mount Solon, VABuilt 1974 · S/N 21060202 N13PCGj Aviation LLC · Mountain Lakes, NJBuilt 1984 · S/N 46-8408081 N13PECamm Air · Spencer, IAS/N TJ-50 N13PGJohnston Steven P · Coto De Caza, CABuilt 1976 · S/N 421C0031 N13TNMcdaniel Robert M · Tonasket, WABuilt 1977 · S/N 21062428 N1400Salour Michael M · Carlsbad, CABuilt 1979 · S/N P210-00277 N140JRobert D Grace LLC · Amarillo, TXBuilt 1981 · S/N 414A0650 N140KBMcclendon Dan · Burleson, TXBuilt 1979 · S/N EA 36 N140KMKnight Edge LLC · Clearwater, FLBuilt 1981 · S/N 414A-0674 N140RBKessler Nicholas · Central Point, ORBuilt 1979 · S/N 310R1807 N140TPHickox Joseph · Rollins, MTS/N 340A0235 N1410URuffcorn Aviation Co · Bettondorf, IABuilt 1982 · S/N 21064693 N1420NKlomhaus Paul · Poplar, WIBuilt 1978 · S/N 310R1398 N1421MClausen Johan Robert · Las Vegas, NVBuilt 1976 · S/N 421C0106 N1421UAviation Services Of Tn Inc · Sparta, TNBuilt 1967 · S/N 421-0046 N142SDSch Aviation Inc Trustee · Kings LynnBuilt 1975 · S/N 414-0635 N143CRNkm LLC · Glasgow, MTBuilt 1993 · S/N EA-550 N144DGSiktberg Timothy J · Nashville, TNBuilt 1999 · S/N LIV-144-P N144JCJackson Construction Aviation LLC · Quitman, TXBuilt 1977 · S/N 340A0360 N144MLLewis University · Romeoville, ILBuilt 2000 · S/N LIV-149 N144RExtrivo Inc · Lewes, DEBuilt 1967 · S/N D-8496 N144WPDresel Av LLC · Fayetteville, ARBuilt 1973 · S/N 21059900 N1450CFreeland Christopher G · Brownwood, TXBuilt 1970 · S/N T21059318 N145TTVenture Air Solutions Inc · Dallas, GABuilt 1977 · S/N 402B1333 N1463CLatta Lutz M · San Francisco, CABuilt 2003 · S/N 1356 N146BUSaltwater Aviation LLC · Friday Harbor, WABuilt 1984 · S/N 46-8408057 N146MSMagnolia Partners Aviation LLC · Lockesburg, ARBuilt 1984 · S/N 46-8408032 N146TAShamash Micah I · Larkspur, COBuilt 1980 · S/N EA-176 N146TJBirdboys2 Aviation LLC · Boerne, TXBuilt 1978 · S/N 421C0500 N146ZUtah State University · Logan, UTBuilt 1982 · S/N TJ-426 N146ZFNo Boundry Airplane LLC · Council Bluffs, IABuilt 1984 · S/N 46-8408002 N147TXTexas Department Of Transportation · Austin, TXBuilt 1979 · S/N U20604987

Back to AD 75-09-13