OpenAirDocs.org
AD 46-31-01

Registered aircraft · 55

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:46-31-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:46-31-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.

N10453Johnson Reed A · Mounds, OKS/N 76-2919N10460Kennedy Michael E · Atlanta, GAS/N 44-03957N10499Todd John M · Flower Mound, TXBuilt 1956 · S/N 45-34960N10569Brewer Brandi R · Fairfield Township, OHS/N 4005N1129NHirzel William J · Walbridge, OHS/N 3576N1552MWullner Leeroy J · Cedar Rapids, IAS/N 4479N1569MHubbard Mark A · Wilmington, DES/N 4598N1570MOcean Toad LLC · Trail, ORS/N 4344N1945SDoggett Jack E Jr · Kingwood, TXS/N 4640N1962MDavis Christopher R · Greenwood, MSS/N 3851N22422American Airpower Heritage Flying Museum · Dallas, TXS/N 44-17191AN2470N2470 LLC · Granite Falls, MNS/N 44-17184N2561CGonzalez Ramiro · Lancaster, OHS/N 4472N2581BPlane Fun Inc Tr Trustee · Snellville, GABuilt 1945 · S/N 120473N2582BEstby Hans P · Hayfield, MNBuilt 1956 · S/N 120466N2584BHein Philip T Trustee · Burlington, WIBuilt 1945 · S/N 45-35012N2745CKnapp Ryan K · Portage, MIS/N 44-18025N31853Aeronautical Educational Foundation · Stockton, CABuilt 1944 · S/N 44-17605N3232SWood Forrest B · Cookson, OKBuilt 1945 · S/N 76-3597N3787CArmstrong Michael K · Spokane, WAS/N 04002N40020Madden Russell · Graford, TXBuilt 1947 · S/N 76-3547N40QWeiland Keith E · Chandler, AZBuilt 1946 · S/N 4611N452WBDemark Aviation Inc · Wilmington, DES/N 76-3462N45CVMarrett George J · Atascadero, CABuilt 1945 · S/N 76-3219N489TSStevenson Taylor A · Addison, TXBuilt 1946 · S/N 4629N5142BAnderson Matthew W · Sherwood, ARS/N 42-98774N5607VBergen Christopher B · Upland, CABuilt 1944 · S/N 2946N5625VAmerican Airpower Heritage Flg Mus · Dallas, TXS/N 44-17590N57WTTsi Holdco Inc · Virginia Beach, VAS/N 3786N60440Rooks Charles Lee · Justin, TXBuilt 1945 · S/N 4010N6055CPlanes Of Fame Air Museum · Chino, CABuilt 1945 · S/N 45-34950N63355Johnson Janis C · Manteca, CABuilt 1945 · S/N 4646N63356Yandik Stephen E · Hudson, NYS/N 4627N63370Cam Air · Caldwell, IDS/N 4625N63397N63397 LLC · Indianapolis, INBuilt 1946 · S/N 4634N63826War History Museum · Memphis, TNS/N 4617N63971Matesick Michael L · Green Springs, OHBuilt 1945 · S/N 4624N63972Tnw Aviation LLC · Clinton, ARS/N 4622N6431CBarclay William G · Peyton, COBuilt 1944 · S/N 3424N6432CClark Edward P · Modesto, ILS/N 3651N66579Wullner Leeroy J · Cedar Rapids, IAS/N 44-18096N67039Anderson David C · Dilley, TXBuilt 1945 · S/N 4318N6707CCrouser Darren W · Mckinney, TXBuilt 1944 · S/N 44-16897N6709CSoderblom Edward J · Ferndale, WABuilt 1944 · S/N 44-17087N68781Registration Pending · Waukesha, WIRegistration pendingBuilt 1955 · S/N 03960N75060Berry Darrel · Camden, TNS/N 44-17674N7618BGronemeyer John Alan · Granbury, TXS/N 44-18190N7728BHokuf Erik L · Bemidji, MNS/N 4037N8071Polsley John Steven · Urbana, OHBuilt 1945 · S/N 4418071N8134AVfr Ltd · Wilmington, DEBuilt 1946 · S/N 4609
Back to AD 46-31-01