OpenAirDocs.org
AD 49-07-03

Registered aircraft · 98

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

N113BTAmerican Airpower Heritage Flying Museum · Dallas, TXS/N 1624N118BGBrothers Aviation LLC · Black Rock, ARS/N 11876N11FWRegistration Pending · Kingsford, MIRegistration pendingBuilt 1942 · S/N 5274N130BTYandik Stephen E · Hudson, NYBuilt 1941 · S/N 1891N133BTAom Aircraft LLC · Wilmington, DEBuilt 1943 · S/N 9683N213BDHoefly Christopher S · Belleview, FLBuilt 1941 · S/N 2514N27003American Airpower Heritage Fly Museu · Dallas, TXBuilt 1942 · S/N 5017N2808Hall Wendell W · Cheraw, SCBuilt 1941 · S/N AAF-41-22410AN313BTEastern Stearman Inc Trustee · Leesburg, VABuilt 1943 · S/N 10425N3571Shackelford John S Jr · Roanoke, TXS/N 3571N369BTCargill James R II · Blaine, MNS/N 2379N4043Elliott Dave P · Boulder, COS/N 5712N413BTTsi Holdco Inc · Virginia Beach, VAS/N 6528N4425VNichols Charles F Trustee · Baldwin Park, CAS/N 79-326N4566VWalnut Ridge Army Flying School Museum Inc DBA · Walnut Ridge, ARS/N 2960N4794NActs Aviation LLC · Fulton, TXS/N 5798N52411American Airpower Heritage Flying · Dallas, TXBuilt 1941 · S/N 2548N52693Ferraro Joseph P · Westfield, INBuilt 1942 · S/N 5674N533BTBock Bryce K · Longwood, FLS/N 10060N54679Norman Royce Kelly · La Feria, TXBuilt 1941 · S/N 2990N54822Planes Of Fame Air Museum · Chino, CABuilt 1944 · S/N 79-947N54841N54841 LLC · Granite Falls, MNBuilt 1941 · S/N 5225N55537Williams David M · Fox Island, WAS/N 2469N55579Old Aeroplane Co LLC · Lake Suzy, FLBuilt 1942 · S/N 3307N55759Brown Michael E Jr · Timmonsville, SCBuilt 1943 · S/N 9920N5582NKoch Bruce R · Goodrich, MIBuilt 1942 · S/N 7543N56319Lineage Flight LLC · Holly Springs, NCBuilt 1941 · S/N 2167N56330Egmond Aircraft LLC · Lewes, DEBuilt 1941 · S/N 2088N56360American Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1942 · S/N 5946N56478American Airpower Heritage Flying Museum · Dallas, TXBuilt 1941 · S/N 7356N56642Meyer Jeffrey · Metamora, ILBuilt 1941 · S/N 6097N56867Mid Atlantic Air Museum · Reading, PABuilt 1945 · S/N 79-1220N56882Smith James E Trustee · Kalispell, MTBuilt 1946 · S/N 79-1682N56915De Freitas Dennis A · Caruthers, CABuilt 1946 · S/N 2252N56985Hurst Thomas Brooks · Tarkio, MOBuilt 1943 · S/N 8557N57387Cousineau Paul J · San Clemente, CABuilt 1942 · S/N 3075N57425Groshong Tedd D · Incline Village, NVS/N 3127N57455Brooks Charles W · Hesperia, CABuilt 1942 · S/N 79-1218N57486American Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1942 · S/N 5665N58577Walnut Ridge Army Flying School Museum Inc DBA · Walnut Ridge, ARS/N 79-1366N58698Valiant Air Group LLC · Hamburg, NYS/N 5836N59572Group 44 Vultee LLC · Dallas, TXS/N 1904N59840Landis Kurt M · Canyon, TXBuilt 1946 · S/N 2459N59842Valiant Effort LLC · Monte Vista, CABuilt 1942 · S/N 5057N59843Medore Douglas A · Romoland, CAS/N 9244LN59961Bishop Nicholas E · Ukiah, CABuilt 1942 · S/N 7722N60277Mid Atlantic Air Museum Inc · Reading, PABuilt 1942 · S/N 6519N60496Colvin George O · Big Cabin, OKBuilt 1945 · S/N 79-671N60794Halladay Roy · Erie, COBuilt 1944 · S/N 91667N60795National Wasp Wwii Museum Inc · Sweetwater, TXBuilt 1943 · S/N 10514
Back to AD 49-07-03