Skip to content

Registered aircraft · 26,231

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

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:94-05-05-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:94-05-05-R1') ORDER BY n_number

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:94-05-05-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:94-05-05-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.

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:94-05-05-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:94-05-05-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N323TBBoatright Kenneth R · Louisville, KYBuilt 1959 · S/N 5705 N3240KJester Andrew R · Santa Claus, INBuilt 1946 · S/N 1233 N3240LWooden Alan L · Signal Mountain, TNBuilt 1967 · S/N 17256140 N3240VAbston Alexandria P · Vancouver, WABuilt 1974 · S/N 15076436 N3241AAirway Science For Kids Inc · Portland, ORBuilt 1953 · S/N 25885 N3241LDostroph Manfred J · Lewis Center, OHBuilt 1967 · S/N 17256141 N3243AChristie Bruce W · Wasilla, AKBuilt 1953 · S/N 25887 N3243NTundra Aviation Inc · Casselton, NDBuilt 1946 · S/N 22435 N3243XPowell Kenneth D · Benton, ARFirst renewal noticeBuilt 1966 · S/N 15064643 N3244APrevail Aviation LLC · Hurley, WIBuilt 1953 · S/N 25888 N3244LKyzer Aviation Holdings LLC · Fort Mill, SCBuilt 1967 · S/N 17256144 N3244NMcleod Charles L · Ocala, FLBuilt 1946 · S/N 22434 N3244XStecks Keith A · Vista, CABuilt 1966 · S/N 15064644 N3245AMoseley Deborah M · Homer, AKBuilt 1953 · S/N 25889 N3245GDougherty Robert E · Mosheim, TNBuilt 1956 · S/N 28326 N3245JAll Sports Aviation LLC · Spokane, WABuilt 1966 · S/N 15065945 N3245KAdair Edward A · Hemet, CAS/N 1238 N3245LGift Academy Inc · Vernon, TXBuilt 1967 · S/N 17256145 N3245XSchneider Alex · Tempe, AZS/N 15064645 N3246KRiggins Construction LLC · Show Low, AZBuilt 1946 · S/N 1239 N3246LStephens David J · Clarence, NYBuilt 1967 · S/N 17256146 N3246NHoneyland Inc · Wolf Point, MTBuilt 1946 · S/N 22438 N3246XRouns Daniel L · Brady, MTBuilt 1966 · S/N 15064646 N32476Currie Mark H · Justin, TXS/N 208 N3247KKroll Cody A · Cincinnati, OHS/N 1240 N3247VHentschel Ernest J · Galloway, NJS/N 15076440 N32482Plane Fun Inc Tr Trustee · Snellville, GABuilt 1941 · S/N 215 N32484Giltner Sam · Gilbert, SCBuilt 1941 · S/N 216 N3248KEngel Eberhard E · Northfield, MNBuilt 1946 · S/N 1241 N324FFMason Michael A · New Carlisle, INBuilt 1969 · S/N A1500142 N324LULetourneau University · Longview, TXS/N 15067538 N324RMBrown Richard K · East Falmouth, MABuilt 2009 · S/N AL-1153 N3250LMiner Jess L · Emmet, NEBuilt 1967 · S/N 17256150 N32515Leonard Danny C · Fort Worth, TXS/N 5-332 N3251LWiles David A · Ozark, ARBuilt 1967 · S/N 17256151 N32522Glover Thomas B · Marana, AZBuilt 1940 · S/N 5417 N3252ABuddenberg Bradford C · Anchorage, AKBuilt 1953 · S/N 25896 N3252KCrnic Paul C · Chesterfield, MOBuilt 1946 · S/N 1245 N3252LElizabethton Aerobatic Club Inc · Elizabethton, TNS/N 17256152 N3253VWilliams Cecil R · Clarksville, TNBuilt 1974 · S/N 15076443 N32546Cooper Roy W · Lamesa, TXBuilt 1940 · S/N 5444 N3254BBeek Dudley E · Miami, FLBuilt 1946 · S/N 1018 N3254CCoon Vernon Ray · Atmore, ALBuilt 1967 · S/N 17256156 N3254HWiens James B · Hillsboro, KSBuilt 1946 · S/N 3879 N3254JCarreiro Myriah L · Candia, NHBuilt 1966 · S/N 15065954 N3254LSelby Thomas A · Fenton, MIBuilt 1967 · S/N 17256154 N3254VRegistration Pending · Bolivar, MORegistration pendingBuilt 1974 · S/N 15076444 N3255LPatton Steven W · Fayetteville, ARS/N 17256155 N32562Young J Craig · Chippewa Falls, WIBuilt 1940 · S/N 5457 N3256KCreager Wes L Md · Hopkinsville, KYFirst renewal noticeBuilt 1946 · S/N 1249

Back to AD 94-05-05 R1