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.

N239ELDingman Marine LLC · Orlando, FLBuilt 1975 · S/N 414-0808 N23DTAlastrom Aviation LLC · Wilmington, DEBuilt 1975 · S/N 421B0852 N23FGState Of California Dept Of Fish & Game · Sacramento, CABuilt 1980 · S/N 18504035 N23GLAtlantic Assets Holding LLC · Dover, DEBuilt 1980 · S/N 414A0509 N23HBHotel Bravo Aviation LLC · Houston, TXFirst renewal noticeBuilt 1977 · S/N 21062050 N23KBRegistered aircraftBuilt 1985 · S/N P21000845 N23RHCajun Crimson Air LLC · Hoover, ALS/N 414A0258 N23RLCaljet Inc · Van Nuys, CABuilt 1981 · S/N 421C1094 N23SJRatnikov Dmitry · Jay, NYBuilt 1981 · S/N EA-222 N240HCBlodgett James R · Walnut Creek, CABuilt 1979 · S/N TJ-221 N240RTAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1975 · S/N 421B0863 N240SQMigster LLC · Miami, FLBuilt 1975 · S/N 310R0273 N24165Yukon Helicopters Inc · Bethel, AKBuilt 1978 · S/N TK-78 N24182Robert Yost Enterprises Inc DBA · Saint Francis, KSBuilt 1978 · S/N TJ-136 N241AREllison Aviation LLC · Conroe, TXBuilt 1967 · S/N 320F-0012 N241MWAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N 421C0030 N241TSGrey Matter Inc · Valley Springs, CAS/N 421B0110 N2423SAircraft Sales LLC · Caledonia, MIBuilt 1976 · S/N 21061275 N2425SPark Sung S · Marana, AZBuilt 1976 · S/N 21061276 N242GDodson International Parts Inc · Rantoul, KSS/N 340A0799 N242HB2hb Airways LLC · Saint Louis, MOBuilt 1970 · S/N 421B0049 N242KABig River Air LLC · Jackson, MSBuilt 1983 · S/N 340A1802 N242RYCity Management Corp · Sunriver, ORBuilt 1978 · S/N P21000036 N2436CHawk Unlimited LLC · Kalispell, MTS/N 30736 N2437UPlanetosea LLC · Doylestown, PABuilt 1983 · S/N 21064782 N2441SSzpara John V Trustee · Chesnee, SCBuilt 1976 · S/N 21061284 N2453SFilipponi-Thompson Drilling Inc · Atascadero, CABuilt 1976 · S/N 21061294 N246BEOn Top Aviation LLC · North Las Vegas, NVBuilt 1976 · S/N 414-0841 N246JJlr Resources LLC · Naples, FLBuilt 1979 · S/N P21000355 N246JWPierson Janice R Trustee · Scio, ORBuilt 1981 · S/N 340A1253 N246KAStahl Richard J · Gainesville, TXBuilt 1984 · S/N 340A1817 N247GNTommy Hanka Farms LLC · Mission, TXBuilt 1968 · S/N TC-1119 N247GSHyannis Air Service Inc DBA · Hyannis, MABuilt 1982 · S/N 402C0637 N247MFsvc Aero Inc · Wilmington, DES/N 288 N248G E Flight Services LLC · Clarksdale, MSBuilt 2001 · S/N EA-678 N2480SAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 21061299 N2498SKatz Michael R Trustee · Merritt Island, FLBuilt 1976 · S/N 21061306 N249CRA&W Air LLC · Aiken, SCBuilt 1979 · S/N TJ-249 N24CFAmerica Aviation LLC · Yuma, AZBuilt 1979 · S/N 340A0659 N24CHDagostini Robert A · Mount Aukum, CABuilt 1975 · S/N 21060793 N24HSSandoval Ernest D · Cave Creek, AZBuilt 1978 · S/N 21062755 N24NHBeyer Roger · Paw Paw, MIBuilt 1981 · S/N 21064545 N24SLSkye Tess Airlines LLC · Holmdel, NJBuilt 1980 · S/N 414A0610 N2507JDarter Lloyd R · Mountain Grove, MOBuilt 1979 · S/N T18803469T N250DCHightower George Jr · Thomaston, GABuilt 1979 · S/N TK-91 N250TCGroth William B · Hixson, TNBuilt 1969 · S/N D-9048 N25120Waconda Concepts LLC · Sturgis, SDBuilt 1985 · S/N 46-8508097 N251WWEbbert Thomas E DBA · Gary, INRegistration revokedBuilt 1967 · S/N 411-0251 N2525XTolbert Mark A · Canandaigua, NYBuilt 1977 · S/N 21061803 N252SLone Peak Air LLC · Gillette, WYBuilt 1980 · S/N 340A0984

Back to AD 75-09-13