OpenAirDocs.org
AD 96-24-17 R1

Registered aircraft · 1,458

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-24-17-R1')
    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-24-17-R1')
  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.

N1830KCurry Gary D · Colorado Springs, COBuilt 1946 · S/N 4557N1833BMills Walter H Jr · Milford, OHBuilt 1948 · S/N 6260N1833KFarrell Brian K · Redding, CABuilt 1946 · S/N 4560N1835KEisen Noam D · Monsey, NYBuilt 1946 · S/N 4562N1836KLapinsky Richard G · Los Lunas, NMBuilt 1946 · S/N 4563N1837BSanders William H · Wichita, KSBuilt 1948 · S/N 6264N1838KLuscombe Endowment Holdings LLC · Gilbert, AZBuilt 1946 · S/N 4565N1839KArmstrong Robert B · Bishop, GABuilt 1946 · S/N 4566N1840BSink Lendon V · Lexington, NCBuilt 1948 · S/N 6267N1840KSlack Jonathan D · Bonfield, ILBuilt 1946 · S/N 4567N1847KConstantino Paulo · Brewster, NYBuilt 1946 · S/N 4574N1848BSouthard Hunter · Knob Noster, MOS/N 6275N1849KMathieson Erik L · Kapowsin, WABuilt 1946 · S/N 4576N1850BEbert Richard D · Owosso, MIBuilt 1948 · S/N 6277N1850KShamlian Paul L · Fallon, NVBuilt 1946 · S/N 4577N1856BWallace Larry W · Millsap, TXS/N 6283N1858KGunder Craig R · Red Lion, PABuilt 1947 · S/N 4585N1859BKruse Adam L · Weiser, IDS/N 6286N1860KDarby Jake B · Manila, ARS/N 4587N1862KGadis Ethan G · Etiwanda, CABuilt 1947 · S/N 4589N1865BSly Duane D · Platte, SDBuilt 1957 · S/N 6292N1866BMorrison William · Nashville, TNBuilt 1948 · S/N 6293N1868KRuddell Farms LLC · Junction City, ORBuilt 1947 · S/N 4595N1869BKinach Virginia Ann Trustee · Laughlin, NVBuilt 1948 · S/N 6296N1869KChiappini Paul · Melrose, FLBuilt 1947 · S/N 4596N1871BSensor Paul A · Hampton, IABuilt 1948 · S/N 6298N1875BWilliams William O · Oswego, ILS/N 6302N1878BSneed Dana L · Kilgore, TXBuilt 1948 · S/N 6305N1880KObrien William D · Duluth, MNBuilt 1947 · S/N 4607N1883KBolton Derwin B · Jacksonville, TXBuilt 1947 · S/N 4610N1891BSmithwick Patrick Michael Trustee · Kiowa, COBuilt 1948 · S/N 6318N1894BHaynes Elton E · Palestine, TXBuilt 1948 · S/N 6321N1897BSherrod Robert W Jr · Burleson, TXBuilt 1948 · S/N 6324N18WSMason Loretta L · Cardington, OHBuilt 1947 · S/N 4737N1902BDurham Terry · Parker, COBuilt 1948 · S/N 6329N1902KBolton Derwin B · Jacksonville, TXBuilt 1947 · S/N 4629N1907BCurrie Mark H · Justin, TXS/N 6334N1908KHarding Nelson · Fort Jones, CABuilt 1947 · S/N 4635N1909BPuls Darrel E · Cotter, ARS/N 6336N1910BMckenna Kent T · Torrance, CABuilt 1948 · S/N 6337N1910KHurlbert Vernon L · Anchorage, AKBuilt 1947 · S/N 4637N1911BJacobson Richard T · Overton, NVBuilt 1948 · S/N 6338N1916BScott Olan H · Naples, FLBuilt 1948 · S/N 6343N1916KMagrini Shawn P · Salem, OHBuilt 1947 · S/N 4643N1917BCraig Gearhart · Three Rivers, MIS/N 6344N1918BBauer Ryan K · Quincy, CABuilt 1950 · S/N 6758N1918KBrown Carl E · Milan, ILBuilt 1947 · S/N 4645N1921KSmeltzer Paul C · Texarkana, ARBuilt 1941 · S/N 1801N1922KPrindle Steven E · Mililani, HIBuilt 1947 · S/N 4649N1924BRichards Thomas E · Saint Jo, TXBuilt 1948 · S/N 6351
Back to AD 96-24-17 R1