OpenAirDocs.org
AD 75-15-06

Registered aircraft · 72

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

N100VQNational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N 140N100WNColumbus State Community College · Columbus, OHBuilt 1979 · S/N 288N101VSCalspan Corporation · Buffalo, NYBuilt 1969 · S/N 218N102VSCalspan Corp · Buffalo, NYBuilt 1974 · S/N 180N107RMDierolf Robert Scott · Carrollton, TXBuilt 1982 · S/N 362N108FLWyoming Aviation Specialist Inc · Green Valley, AZS/N 300N111FNBest Aircraft Deals LLC · Salt Lake City, UTS/N 293N119BARegistration Pending · Tucson, AZRegistration pendingBuilt 1965 · S/N 23-084N123DGDavis Air LLC · Vero Beach, FLBuilt 1976 · S/N 342N143CKWings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 143N165CMUS Crane LLC · Wilmington, DES/N 355N166PCTechnical Education Services Inc · Virginia Beach, VABuilt 1970 · S/N 166N175FSJet Set 1 LLC · Kalispell, MTBuilt 1965 · S/N 031N17AHSpirit Wing Aviation Ltd · Guthrie, OKBuilt 1980 · S/N 316N193DBDakota Territory Air Museum · Minot, NDS/N 193N1965LMuseum Of Flight Foundation · Seattle, WABuilt 1965 · S/N 012N200YClassic Lear Jet Foundation · Wichita, KSS/N 23-003N203VSCalspan Corp · Buffalo, NYBuilt 1981 · S/N 347N237TWTechnical Education Services Inc DBA · Virginia Beach, VABuilt 1970 · S/N 237N23BYYounkin Matthew A · Siloam Springs, ARBuilt 1965 · S/N 23-009N249HPSale Reported · Camden, DESale reportedBuilt 1975 · S/N 301N24SAviation Sales And Charter LLC · Dover, DES/N 297N24SAClark Lloyd E · Hanover, MDS/N 24-117N24WXTre Aviation Corp · Wilmington, DEBuilt 1966 · S/N 101N251TSLopez Fabio A · Denver, NCBuilt 1975 · S/N 201N25CYN25cy LLC · West Palm Beach, FLS/N 272N25NYAndrews University · Berrien Springs, MIBuilt 1980 · S/N 304N25PWSolomon Mark Trustee · Wilmington, DEBuilt 1981 · S/N 342N26ATDel Mar College · Corpus Christi, TXBuilt 1973 · S/N 130N27BJCbg LLC · Wilsonville, ORBuilt 1971 · S/N 227N293MCTechnical Education Services Inc DBA · Virginia Beach, VABuilt 1974 · S/N 24-293N295NWAmerican Trans Air T/A · Phoenix, AZBuilt 1974 · S/N 295N304VSCalspan Corp · Buffalo, NYBuilt 1981 · S/N 354N3137Avstar Inc · Seattle, WABuilt 1966 · S/N 123N330LA-C Electric Co · Bakersfield, CABuilt 1981 · S/N 330N352MDDolphin Aviation LLC · Tulsa, OKBuilt 1977 · S/N 352N400MSMil Oh LLC · Camden, DEBuilt 1972 · S/N 246N4447PAviation Management & Repairs Inc · Fort Pierce, FLS/N 338N444TGAmerican Trans Air Training Corp · Virginia Beach, VABuilt 1980 · S/N 327N456CGLdl Aircraft Leasing LLC · Pittsfield, MABuilt 1981 · S/N 343N45ED45ed LLC · Calhoun, GABuilt 1966 · S/N 104N473TCTulsa Technology Center School District #18 · Tulsa, OKBuilt 1969 · S/N 043N477KRegistered aircraftBuilt 1965 · S/N 23036N48CTBank Of Utah Trustee · Salt Lake City, UTBuilt 1973 · S/N 274N499BSNational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N 239N49GSAvstar Inc · Seattle, WABuilt 1976 · S/N 336N49WAFleet Unlimited Inc · Pasadena, CABuilt 1973 · S/N 142N555LJBeck Angelique Verschuur · Ione, CAS/N 195N564CLDavid Copperfield Project Magic Fund · Las Vegas, NVBuilt 1976 · S/N 25-060N56MMCarlisle Air LLC · Locust Valley, NYBuilt 1976 · S/N 332
Back to AD 75-15-06