OpenAirDocs.org
AD 46-31-02

Registered aircraft · 130

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-02')
    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-02')
  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 3576N1156VAmerican Airpower Heritage Flg Musm · Dallas, TXBuilt 1943 · S/N 60507N121MCAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1944 · S/N 761684N1252Iowa Military Aviation Heritage Museum · Ankeny, IABuilt 1942 · S/N 42-98196N142LBFleischer Gregory P · Flower Mound, TXBuilt 1942 · S/N 42-98694GFN14863Asher Gerald W · N Richland Hills, TXS/N 7666N1548MIwo Jima Sentinel LLC · Dover, DES/N 02747N1552MWullner Leeroy J · Cedar Rapids, IAS/N 4479N1569MHubbard Mark A · Wilmington, DES/N 4598N1570MOcean Toad LLC · Trail, ORS/N 4344N1718MGriffin John M · Carriere, MSS/N 42-14927N17270Vfr Ltd · Wilmington, DES/N 4475N194Skyraider A1e LLC · Rocky Hill, CTBuilt 1945 · S/N 3567N1945SDoggett Jack E Jr · Kingwood, TXS/N 4640N1962MDavis Christopher R · Greenwood, MSS/N 3851N198RBOflanagan Clancy H · Chowchilla, CABuilt 1942 · S/N 4298633N22422American Airpower Heritage Flying Museum · Dallas, TXS/N 44-17191AN227BCL-5 Aviation Consulting LLC · Spring Hill, FLBuilt 1942 · S/N 76-868N2470N2470 LLC · Granite Falls, MNS/N 44-17184N255DBEgmond Aircraft LLC · Lewes, DEBuilt 1942 · S/N 76-050N2561CGonzalez 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-18025N29846Military Aircraft Restoration Corp · Anaheim, CABuilt 1944 · S/N 76-709N31853Aeronautical Educational Foundation · Stockton, CABuilt 1944 · S/N 44-17605N3232SWood Forrest B · Cookson, OKBuilt 1945 · S/N 76-3597N3706CGustafson Gail M · White Hall, MDS/N 3861N3787CArmstrong Michael K · Spokane, WAS/N 04002N40002War Eagles Air Museum · Santa Teresa, NMBuilt 1943 · S/N 76-220N40003Horton Timothy A · Carmichael, CABuilt 1943 · S/N 76390N40020Madden Russell · Graford, TXBuilt 1947 · S/N 76-3547N40480Armstrong Michael K · Spokane, WABuilt 1942 · S/N 76-517N40QWeiland Keith E · Chandler, AZBuilt 1946 · S/N 4611N4381ZLaing Malcolm Brian · Lubbock, TXS/N 42-98333N452WBDemark Aviation Inc · Wilmington, DES/N 76-3462N4584Inzana Anthony F II · Hughson, CABuilt 1944 · S/N 42-99497N45CVMarrett George J · Atascadero, CABuilt 1945 · S/N 76-3219N45TXLux William E · Newman Lake, WAS/N 44-17397N46JBSchreiber Beck Cynthia K · Wahpeton, NDBuilt 1946 · S/N 76-269N48083Texas Air Museum · Slaton, TXS/N 42-98801N489TSStevenson Taylor A · Addison, TXBuilt 1946 · S/N 4629N4914Brubaker Gregory L · Layton, UTS/N 1120N49279Straight Arrow LLC · Chicago, ILBuilt 1943 · S/N 76-512N49324Vfr Ltd · Wilmington, DEBuilt 1943 · S/N 76-530
Back to AD 46-31-02