Skip to content

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

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

N103GClifford Michael P · Paris, TXBuilt 1950 · S/N A533 N1140Beechboys Aviation LLC · Wilmington, DEBuilt 1946 · S/N A-129 N118DJInternational Air Services Inc Trustee · Carson City, NVBuilt 1943 · S/N 43-35634 N121SCNorth Bay Air Museum · Sonoma, CABuilt 1946 · S/N A-85 N127MLNiemyjski Justin · Franksville, WIBuilt 1946 · S/N A-212 N145AZAmerican Airpower Heritage Flying Museum Inc · Dallas, TXS/N A-235 N1801DKlaers Lawrence B · Waconia, MNBuilt 1952 · S/N A-816 N1828DWalker Matthew James · Henderson, NVBuilt 1952 · S/N A-837 N197LAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1947 · S/N A-361 N21CAJorgensen Bryan H · Wadsworth, OHBuilt 1946 · S/N A-250 N223CMPlane Fun Inc Tr Trustee · Snellville, GABuilt 1952 · S/N CA223 N2913BW Air Collection Inc Trustee · Wilmington, DEBuilt 1953 · S/N A-963 N30GAg Air Inc · Matthews, MOBuilt 1946 · S/N A-131 N3111Setter Thomas D · Burnsville, MNBuilt 1953 · S/N A-964 N33JPScenic Flight Adventures LLC · Coeur D Alene, IDBuilt 1954 · S/N A-998 N3500BWalter Charles T Jr · Ocala, FLBuilt 1953 · S/N A-973 N3532BPlane Crazy Aviation LLC · Hollywood, SCBuilt 1954 · S/N A-999 N411JAukes Brian E · Huxley, IABuilt 1953 · S/N A-967 N41289Nizex Inc · Jackson, GAS/N A-475 N412KKourtis Vintage Aviation LLC · Owasso, OKBuilt 1946 · S/N A-263 N42114Spiller Gary W · Lafayette, ORS/N 39815 N42CStage One Associates LLC · Oxford, CTS/N A-468 N4356GTop Hand Inc · Laurel, MTBuilt 1951 · S/N CA56 N43927Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1945 · S/N A-26 N44607Shepard Group LLC · Mena, ARBuilt 1945 · S/N A-15 N44638Vintage Aircraft Inc · Stockton, CAS/N A-45 N4477Parish John Sr · Tullahoma, TNBuilt 1952 · S/N A-935 N4DHGlenn L Martin Maryland Aviation Museum · Baltimore, MDBuilt 1946 · S/N A-260 N52DNAir Apparent Aviation LLC · Plant City, FLBuilt 1952 · S/N A-846 N5804CGeorge Andrew N · Corvallis, ORBuilt 1951 · S/N A579 N5QQBowe Walter C Trustee · Sonoma, CABuilt 1946 · S/N A-223 N62936Prop And Jet Air Museum · Romoland, CAS/N CA38 N649BSpirit Engineering Inc · Grand Junction, COBuilt 1948 · S/N A-454 N651BSjc IV LLC · Lawrence, KSBuilt 1949 · S/N A-478 N6623Szostak Edward M · San Diego, CABuilt 1946 · S/N A-295 N6BAMcmanigle Jeff · Osakis, MNBuilt 1946 · S/N A-406 N70GAAmerican Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1966 · S/N A-177 N70WWIsland City Seaplanes Inc · Cordova, AKS/N A-38 N73548Smith Salvage And Restoration Services LLC · New Berlin, TXS/N A-548 N75JCWilliams Austin · Valdosta, GABuilt 1946 · S/N A-256 N79AGAmerican Airpower Heritage Fly Musm · Dallas, TXBuilt 1952 · S/N A-806 N80036Beechcraft Heritage Museum · Tullahoma, TNBuilt 1946 · S/N A-187 N80152Culpepper Matt D · Las Vegas, NVBuilt 1946 · S/N A-112 N80197Pgt Nuclear LLC · College Station, TXS/N A-171 N80373Virgil J Tatman · Casper, WYS/N A-273 N80388Valiair Lc Trustee · Casper, WYBuilt 1946 · S/N A-288 N843TBFarwell Jesse R · Albion, NYS/N A217 N868LSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1946 · S/N A-173 N90460Mitchell Aircraft Components Inc · Borrego Springs, CABuilt 1958 · S/N A-937 N90502Glover William Scott · Mt Pleasant, TXBuilt 1947 · S/N A-346

Back to AD 47-33-06