AD 75-06-01

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
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.

N290BCTraven Ricardo Siro · Georgetown, SCBuilt 2004 · S/N 1092N290CCMonument Aviation LLC · North Chesterfield, VABuilt 1966 · S/N LJ132N290PASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1971 · S/N LJ-519N291DFRmb Leasing Inc · Dover, DEBuilt 1998 · S/N LJ-1534N292KQNortheast Elite Aviation LLC · Oakland, MEBuilt 2013 · S/N 100-0092N292PSteelman Aviation Inc · Las Vegas, NVBuilt 2005 · S/N 630N293KDKodiak Special LLC · Huntsville, ALBuilt 2021 · S/N 100-0293N294DRValiair Lc Trustee · Casper, WYBuilt 2004 · S/N 4697184N294LARoma Air Corp · Belle Glade, FLBuilt 2000 · S/N 802A-0094N294TTUncommon Solutions LLC · Hollis, NHBuilt 1984 · S/N LJ1098N294ZPCumulus Aviation Inc Trustee · Wilmington, DEBuilt 1980 · S/N 31T-8020063N295DCHibiscus26 Inc Trustee · Wilmington, DEBuilt 2000 · S/N BB-1709N297KDAir Sansone LLC · New Castle, DEBuilt 2021 · S/N 100-0297N298KDKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2021 · S/N 100-0298N299AVTeton Leasing LLC · Pocatello, IDBuilt 1999 · S/N BB-1680N299CZN299cz LLC · Milwaukee, WIBuilt 1969 · S/N U74N299MKBoman & Kemp Manufacturing Inc · Ogden, UTBuilt 1990 · S/N BB1357N299RPGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1537N299VMSs Leasing LLC · Tulare, CABuilt 1986 · S/N LJ-1125N29ANSouth Aero Inc · Albuquerque, NMBuilt 1999 · S/N 208B0753N29MBluesky Geospatial Ltd · North Adams, MABuilt 1973 · S/N LW88N29MGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 208B0812N2AVRegistration Pending · Scottsdale, AZRegistration pendingBuilt 1985 · S/N 20800057N2GGN2gg Leasing LLC · Ponca City, OKBuilt 1996 · S/N BB-1539N2MKItalian Job Holdings LLC · Johnstown, OHBuilt 2003 · S/N 1063N30019O & K Aviation Inc · Newport, ARS/N T45007DCN3004WMiddle Georgia Aviation Inc · Cochran, GABuilt 1995 · S/N T42209DCN300AEColumbia Asset Trust Corp Trustee · Wichita, KSS/N 97N300BFBasler Turbo Conversions LLC · Oshkosh, WIBuilt 1943 · S/N 26744N300KAHeartland Aviation LLC · Ada, OKBuilt 1990 · S/N FL-28N300PTGjf Enterprises Inc · Port Orange, FLBuilt 1984 · S/N FA-34N300TMTaylor & Martin Enterprises Inc · Fremont, NEBuilt 1991 · S/N FL-50N300WJAthens Aviation LLC · Wilmington, DEBuilt 1977 · S/N BB-319N300WMWalker Manufacturing Co · Fort Collins, COBuilt 1988 · S/N FA156N301CLWin Win Aviation Inc · Wake Forest, NCBuilt 1969 · S/N 221N302PSF90x LLC · Modesto, CABuilt 1990 · S/N FA-213N30397Rust Raymond H III · Nacogdoches, TXBuilt 2003 · S/N 4697167N303GVState Of Alaska · Palmer, AKBuilt 1996 · S/N 208B0581N303JWKey Investment Holdings LLC · Horseshoe Bay, TXBuilt 2002 · S/N 4697149N303RRG2 Leasing LLC · Fargo, NDBuilt 1997 · S/N FL-178N304JSRegistration Pending · Pharr, TXRegistration pendingBuilt 1988 · S/N FA142N3051KBuilding Corp LLC · Huntsville, TXBuilt 1994 · S/N BB-1495N3052KUas Transervices Inc · Boca Raton, FLBuilt 1987 · S/N UB-70N305ELRoper Aviation LLC · Wilmington, DEBuilt 1981 · S/N BB947N3066WFortis Aircraft Leasing LLC · Reno, NVBuilt 1998 · S/N LJ-1536N307RWRomeo Whiskey LLC · Klamath Falls, ORBuilt 2017 · S/N 100-0230N307SBSan Bernardino County Sheriffs Aviation Division · San Bernardino, CABuilt 1975 · S/N 30781N307YPVillages Equipment Co · Leesburg, FLBuilt 2024 · S/N 100-0340N3080FGreyhawk Aviation LLC · Ketchum, IDBuilt 1999 · S/N FL-249N30898Painter Andrew S · Harlingen, TXBuilt 2005 · S/N 4697202
Back to AD 75-06-01