AD 92-07-05

Registered aircraft · 945

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:92-07-05')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:92-07-05')
  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.

N121JPChoice Farms LLC · Wilmington, DEBuilt 1998 · S/N LJ-1520N122KMerlin Labs Inc · Boston, MABuilt 1976 · S/N LJ-707N123FWBhmp King Air LLC · Fort Worth, TXBuilt 2001 · S/N LJ-1655N123MHBryan-Kennedy LLC · Tulsa, OKBuilt 1974 · S/N LW-104N125NJAircraft Partner Holdings Inc Trustee · Fallbrook, CABuilt 1982 · S/N LJ-1045N126MMFreeman Holdings Of West Texas LLC · Medford, ORBuilt 2002 · S/N LJ-1669N126WAJpg & Aog LLC · Concord, NCBuilt 1984 · S/N LJ1093N127MUSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1985 · S/N LJ-1102N127TXItb Solutions LLC · Palm City, FLBuilt 1981 · S/N BE-106N127ZWAerolease LLC · Fargo, NDBuilt 1994 · S/N LJ1369N129LABluebird 2000 LLC · Wilmington, DES/N LJ-129N129TNGuardian Flight LLC · Lewisville, TXBuilt 2005 · S/N LJ-1742N12AXEsc-100 Executive Consulting Services LLC · Pharr, TXBuilt 1978 · S/N LW-293N12GJBuilding Ideas Inc · Los Gatos, CABuilt 1972 · S/N LW-12N12LACentral Virginia Aviation Inc · Petersburg, VAS/N LW-49N130GPUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U-222N131BLLta Group Holdings LLC · Amarillo, TXBuilt 2001 · S/N LJ-1654N131GPUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U225N132HSCentral Virginia Aviation Inc · Petersburg, VABuilt 1972 · S/N LW-8N135AAKentucky King Air LLC · Hazard, KYBuilt 1985 · S/N LJ-1112N136PAX-Press Charter Service Inc · Longview, TXBuilt 1975 · S/N LJ662N137BABemidji Aviation Services Inc · Bemidji, MNBuilt 1970 · S/N U137N139JBQuay Ventures LLC · Alto, TXBuilt 1979 · S/N BE-81N139SCNew Ulm C90 LLC · Marshall, MNBuilt 1979 · S/N LJ868N13GZGuardian Flight LLC · South Jordan, UTBuilt 2000 · S/N LJ-1590N140HAxis Transportation Services LLC · Sacramento, CABuilt 2005 · S/N LJ-1753N140PAJump Plane Of Pittsburgh LLC · Mercer, PABuilt 1967 · S/N LJ-297N143FWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N LJ-1612N145AFDale Aviation Inc · Rapid City, SDS/N LJ-1721N147LJGuardian Flight LLC · Lewisville, TXS/N LJ-1476N14NMDriscoll Health Care Services · Corpus Christi, TXBuilt 1973 · S/N LW-35N14SBMountain Air Aviation LLC · Jonesville, VAS/N LW-214N14VDouble D International LLC · Miami, FLS/N LJ-411N150GWRocinante Air LLC · Cincinnati, OHBuilt 1998 · S/N LJ-1531N150TWCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1973 · S/N LW-50N150VECarnes 150ve LLC · Wichita Falls, TXBuilt 1975 · S/N LJ-678N152WWNardi Greg · Missoula, MTS/N LJ-654N1544VGuardian Flight LLC · Lewisville, TXBuilt 1994 · S/N LJ-1366N1552DDodson International Parts Inc · Rantoul, KSBuilt 1989 · S/N LJ-1204N1552GEast Atlantic Aviation LLC · Edenton, NCBuilt 1989 · S/N LJ-1206N1553GMccloy Mark · Tatum, NMBuilt 1989 · S/N LJ-1214N155LSRainair Avionics Services LLC · Albertville, ALS/N LW-286N156GAlliance Air Parts Acquisitions Corp · Oklahoma City, OKBuilt 1975 · S/N LW-156N157MHMile Hi Skydivers Inc · Longmont, COS/N LW157N15CTSkydive Grand Haven LLC · Grand Haven, MIBuilt 1966 · S/N LJ-192N162STState Of Michigan · Lansing, MIBuilt 1978 · S/N LW-300N164WSBank Of Utah Trustee · Salt Lake City, UTS/N LJ-1736N167BBCentral Virginia Aviation Inc · Petersburg, VABuilt 1983 · S/N LJ-1054N1685SBella Vista Transportation & Rentals LLC · Dunnellon, FLS/N LJ-1685N169DRLegacy Aviation LLC · Tea, SDBuilt 1989 · S/N LJ-1205
Back to AD 92-07-05