Registered aircraft · 2,832

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-06-01') 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-06-01') 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-06-01')
    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-06-01')
  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-06-01')
  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-06-01')
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.

N1296YPa1 208b-1079 LLC · Fort Lauderdale, FLBuilt 2004 · S/N 208B1079 N129EJShelbyville Auto Sales LLC · Shelbyville, TNBuilt 2001 · S/N 4697065 N129EMAdams Aviation Services Inc Trustee · Wilmington, DES/N UE-229 N129JWAir Methods LLC · Greenwood Village, COBuilt 1996 · S/N 129 N129LABluebird 2000 LLC · Wilmington, DES/N LJ-129 N129LCL R & F LLC · Dover, DEBuilt 1979 · S/N 31T7904042 N129TPHljh LLC · Corpus Christi, TXBuilt 2005 · S/N 629 N12FAWilke Aviation Group LLC · College Station, TXBuilt 1995 · S/N 117 N12GJBuilding Ideas Inc · Los Gatos, CABuilt 1972 · S/N LW-12 N12LUDonalds Flying Service Inc · Pantego, NCBuilt 1998 · S/N T15-037DC N12MNMinnesota Department Of Transportation · Saint Paul, MNBuilt 2024 · S/N 100-0342 N131GPUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U225 N131SAPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 46020113 N131SJGravitas Aviation LLC · Dallas, TXBuilt 1976 · S/N BB-131 N131SPKauffman Land & Development LLC · Denver, COBuilt 1983 · S/N LA-206 N1322TStrain Aviation LLC · Arbuckle, CABuilt 2015 · S/N 100-0135 N1323RWright Air Service Inc · Fairbanks, AKBuilt 1999 · S/N 208B0745 N1323YState Of Alaska · Anchorage, AKBuilt 2001 · S/N 20800352 N1324GProps & Jets Inc · Dover, DEBuilt 1999 · S/N 208B0777 N132KCAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-132 N132TJVertol Systems Company Inc · Destin, FLBuilt 2011 · S/N 173 N133GAJab Aire LLC · Wilmington, DEBuilt 1989 · S/N BB1321 N133KQValiair Lc Trustee · Casper, WYBuilt 2014 · S/N 100-0133 N134ME D Santos & Associates LLC Trustee · Wilmington, DEBuilt 2003 · S/N 4697169 N1350AAlaska Skypower LLC · Fairbanks, AKBuilt 1944 · S/N 33032 N135CKStellar Aviation LLC · Williamstown, NJBuilt 1999 · S/N 208B0776 N135FLAfdflt LLC · Mount Vernon, ILBuilt 2002 · S/N 4697135 N135LTFleming William D · Litchfield, ILBuilt 1997 · S/N 135 N135RFRandigo LLC · Wilmington, DEBuilt 1996 · S/N 208B0551 N136CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0037 N136PAX-Press Charter Service Inc · Longview, TXBuilt 1975 · S/N LJ662 N137BABemidji Aviation Services Inc · Bemidji, MNBuilt 1970 · S/N U137 N138JMFull Throttle Aviation LLC · Clayton, DEBuilt 1991 · S/N 7 N139MCBilly Bobs Flying Service LLC · Bay, ARBuilt 2024 · S/N 510-139 N139SCNew Ulm C90 LLC · Marshall, MNBuilt 1979 · S/N LJ868 N13FPSafeco Leasing LLC · Port Alsworth, AKS/N B-44 N13GXEpic II LLC · Reno, NVBuilt 2023 · S/N K040 N13GZGuardian Flight LLC · South Jordan, UTBuilt 2000 · S/N LJ-1590 N13SUDownwind LLC DBA · Salt Lake City, UTBuilt 2009 · S/N 152 N140MCPlane To Sea LLC · Raleigh, NCBuilt 1996 · S/N FL-140 N141DZLiam 750 Inc · Charlevoix, MIBuilt 2008 · S/N XL 150 N141MHCinema Aircraft Executive Transportation LLC · Las Vegas, NVBuilt 1997 · S/N 760465 N1421ZMng Leasing LLC · Bottineau, NDBuilt 1998 · S/N 140 N142DVSalerno Robert J · Cornwall, NYBuilt 2015 · S/N 100-0142 N142EEHound Dog Aircraft LLC · Lawrence, KSBuilt 2005 · S/N 4697217 N143AUSkydive Guam Inc · Barrigada, GUBuilt 2005 · S/N 125 N143FWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N LJ-1612 N143ZUsda Forest Service Fire & Aviation · Boise, IDBuilt 1974 · S/N 437 N144CMeyers Construction Inc · Fresno, CABuilt 1991 · S/N FL-49 N144JTFlight 1976 LLC · Kennesaw, GABuilt 1999 · S/N 144

Back to AD 75-06-01