Registered aircraft · 64

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

N105CAChampaign Aviation Museum · Urbana, OHBuilt 1944 · S/N 25720 N115NABasler Turbo Conversions LLC · Oshkosh, WIS/N 11625 N115SABasler Turbo Conversions LLC · Oshkosh, WIS/N 13310 N130DQuigg Gary F · Crawfordsville, INBuilt 1943 · S/N 19800 N130QHbf Inc · Greenville, MEBuilt 1943 · S/N 11761 N133DMoss Frank V · Punta Gorda, FLBuilt 1936 · S/N 1499 N1350AAlaska Skypower LLC · Fairbanks, AKBuilt 1944 · S/N 33032 N138DMuseum Of Flight Foundation · Seattle, WABuilt 1940 · S/N 2245 N141JRThirsty 13th LLC · Dallas, TXBuilt 1944 · S/N 19366 N143DReiley Hunter W · Harlingen, TXBuilt 1937 · S/N 2054 N150DQualitair LLC Trustee · MichelstadtBuilt 1941 · S/N 4463 N15MAFlorida Air Cargo · Davie, FLBuilt 1942 · S/N 19286 N16005N1944m LLC · Wilmington, DEBuilt 1942 · S/N 19394 N16070Falls At Mcminnville LLC · West Jordan, UTBuilt 1936 · S/N 1910 N167TWBasler Turbo Conversions LLC · Oshkosh, WIS/N 26005 N1944AWeeks Kermit A · Polk City, FLBuilt 1944 · S/N 19677 N1945Save A Connie Inc · Kansas City, MOBuilt 1941 · S/N 3294 N1XPDuggy Foundation · Page, NDBuilt 1942 · S/N 4733 N24320Museum Of Mountain Flying · Missoula, MTBuilt 1944 · S/N 20197 N25641Jb Air Services LLC · Brighton, COBuilt 1943 · S/N 9059 N26MAPm Leasing Inc · Perris, CABuilt 1939 · S/N 2169 N271SEFlorida Air Cargo Inc · Davie, FLBuilt 1945 · S/N 15676/27121 N2805JAmerican Flight Museum Inc · Topeka, KSBuilt 1944 · S/N 20835 N28341Delta Air Lines Inc · Atlanta, GABuilt 1940 · S/N 3278 N28TNDena'Ina Leasing Agency LLC · Anchorage, AKBuilt 1952 · S/N 43354 N300BFBasler Turbo Conversions LLC · Oshkosh, WIBuilt 1943 · S/N 26744 N300MFMissionary Flights And Services Inc DBA · Fort Pierce, FLBuilt 1944 · S/N 32961 N3239TValiant Air Command Inc · Titusville, FLBuilt 1987 · S/N 19054 N3291International Air Services Inc Trustee · Carson City, NVBuilt 1940 · S/N 2204 N33623Dakota Aviation Museum Inc · Mason, NHBuilt 1944 · S/N 20215 N33632Ahcw North Central Dc-3 LLC · Sheboygan Falls, WIS/N 4138 N33VWKourtis Vintage Aviation LLC · Owasso, OKS/N 20401 N345AB1941 Historical Aircraft Group Museum · Geneseo, NYBuilt 1943 · S/N 13803 N346ABAmerican Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1945 · S/N 16693 N353MMMartin Aviation LLC · Warren, NJBuilt 1944 · S/N 13541 N400MFDc-3 LLC · Juneau, AKBuilt 1944 · S/N 26877 N408DAmerican Aerolux LLC · Sparta, TNBuilt 1940 · S/N 2247 N431HMPlane Fun Inc Tr Trustee · Snellville, GAS/N 9995 N43XXValiair Limited Co Trustee · Casper, WYBuilt 1943 · S/N 11665 N472AFVintage Wings Aircraft LLC · Center Point, INBuilt 1944 · S/N 13485 N5106XPleasant Aviation LLC · Mount Pleasant, TXBuilt 1943 · S/N 9058 N534BESkytroopers LLC · Dover, DES/N 4932 N566PTPriority Air Charter LLC · Kidron, OHBuilt 1944 · S/N 13346 N574JBWar Eagles Air Museum · Santa Teresa, NMBuilt 1944 · S/N 20145 N57626Nord Aviation Inc · Pembina, NDBuilt 1943 · S/N 4564 N60154Palm Springs Air Museum · Palm Springs, CABuilt 1943 · S/N 32755 N63440Alaska Crew Inc · Anchorage, AKS/N 20194 N64784Cleveland Detroit Flying Service LLC · Solvang, CAS/N 14037 N715FLsa LLC · Kalispell, MTBuilt 1941 · S/N 4129 N74589Tunison Foundation Inc · Oxford, CTBuilt 1942 · S/N 9926

Back to AD 92-06-15