AD 96-03-13

Registered aircraft · 1,042

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:96-03-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:96-03-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.

N69084Konen Rock Products Inc · Milton Freewater, ORBuilt 1982 · S/N LA-157N690SCN690sc One LLC · Dover, DEBuilt 1983 · S/N BB-1139N694KMCarling Technologies Inc · Plainville, CTS/N BB-1922N697PStaker & Parson Co · Ogden, UTBuilt 1985 · S/N BB1217N699ALBallard Aviation Inc · Newton, KSBuilt 1980 · S/N BE-83N699BWBeech Transport LLC · Tarboro, NCBuilt 1999 · S/N BB-1658N699CZN699cz LLC · Milwaukee, WIBuilt 1968 · S/N U-10N6VJN6vj LLC · Coleman, FLS/N LA88N700BAAviation Inventory Resources Inc · Alvarado, TXBuilt 1980 · S/N BE-84N700LXLimpia Logistics LLC · Midland, TXBuilt 1999 · S/N BB-1657N700NAAtlanta Air Charter Inc · Kennesaw, GABuilt 1994 · S/N BB-1491N700ZAti Aviation LLC · Johnstown, PAS/N BB-1920N702MAZion Asset Management LLC · Saint Clair Shores, MIS/N BB-1010N703LTAt Aero LLC · Wilmington, DEBuilt 1980 · S/N BB753N703MDavis Aviation Inc DBA · Brandon, MSBuilt 1977 · S/N BB-271N70CULou Dell Aviation LLC · Simpsonville, SCBuilt 1981 · S/N BB-888N70JJWilmington Trust Co Trustee · Wilmington, DEBuilt 1988 · S/N BL-130N70MNState Of Minnesota · Saint Paul, MNBuilt 1993 · S/N BB-1447N70NPBemidji Aviation Services Inc · Bemidji, MNBuilt 1968 · S/N U-14N710JBSunset Leasing Inc · Sarasota, FLBuilt 2001 · S/N BB-1784N710NCNorth Country Aviation Inc · Gaylord, MIBuilt 1977 · S/N BB-322N711LFlorida Aero Services S D · Brandon, FLBuilt 1984 · S/N LA-222N711REMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1976 · S/N B-233N711VVMaynard Aviation LLC · Westfield, MABuilt 1990 · S/N BB-1365N712RHBtr Air Charter-Ka LLC · Baton Rouge, LAS/N BB-1839N713RHFalcon Air LLC · Olive Branch, MSBuilt 1987 · S/N BB-1274N715RDHalls Aviation LLC · Charleston, SCBuilt 1980 · S/N BB-707N716APButler Aviation Inc · Houma, LABuilt 1978 · S/N BB-448N716AVMas Trailers LLC · Dalhart, TXS/N BB-1876N716TAB P Air LLC · Delhi, LAFirst renewal noticeBuilt 1995 · S/N BB-1509N717DCAircraft Unlimited Inc · Pierre, SDS/N BB-1261N717VAAtlanta Air Charter Inc · Kennesaw, GABuilt 2007 · S/N BB-1994N719BHWilliams Farms LLC · Panhandle, TXBuilt 1979 · S/N BB-564N71VTWestern Wings Corp · Roseburg, ORBuilt 1980 · S/N BB-709N7206EEt Aviation LLC · Alcoa, TNS/N LA-234N720AMKing Eagle II LLC · Grand Blanc, MIBuilt 1999 · S/N BB-1663N720COscar Charlie LLC · California, MDBuilt 1973 · S/N B-171N721EAAcellerated Interventional Orthopedics Pllc · Lawton, OKBuilt 1980 · S/N BB-679N721RDKing Edward Inc · Cullman, ALBuilt 1980 · S/N BB677N721RFEdgington Transport LLC · Livermore, CABuilt 1982 · S/N LA-190N722BRB&L Aviation LLC · North Myrtle Beach, SCBuilt 2000 · S/N BB-1701N722TRJamair LLC · Poland, OHBuilt 1981 · S/N BB-938N724AAAlbright Insurance Holdings Inc · Burlington, NCBuilt 1998 · S/N BB-1632N7250TEpic Aviation Inc · New Smyrna Beach, FLBuilt 1985 · S/N BB-1237N725RABar Environmental Supply Inc · Brentwood, TNBuilt 1980 · S/N BB-725N727BCue Capital LLC · Edmond, OKBuilt 2000 · S/N BB-1734N727BWAcc4m LLC · Augusta, GABuilt 1981 · S/N BB-861N72HTSan LLC · Knoxville, TNBuilt 1984 · S/N BB-1153N730HMIsr Aviation LLC · Wilmington, DEBuilt 1999 · S/N BB-1648N744PCCorzon Aircraft Sales LLC · Highland Park, ILBuilt 2003 · S/N BB-1815
Back to AD 96-03-13