Registered aircraft · 336

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

N101BWEdmonds Louis R W · Georges Mills, NHS/N 121-42854 N101FTTelling Jennifer W · Port Orange, FLBuilt 1949 · S/N 49-3380 N101NZSwift Stephen · Justin, TXBuilt 1944 · S/N 41-34050 N101VTAas LLC · Ovid, MIBuilt 1958 · S/N 88-13384 N102MCCase Martin V Jr · Euless, TXS/N 42-85647 A/MC N104DCBudde-Jones Kathryn M · Celebration, FLBuilt 1949 · S/N 49-3392 N1054MYaggie Allen R · Wahpeton, NDBuilt 1950 · S/N 49-3044 N10597Sanders Racing Inc · Jasper, ALBuilt 1957 · S/N 88-13364 N10602Hatfield Aviation LLC · Fort Wayne, INBuilt 1944 · S/N 121-41870 N107FGTwin Lakes Aviation LLC · Edmond, OKBuilt 1944 · S/N 44-80858 N109NAOmega 1 Corp · Middletown, DES/N 168-109 N11171American Airpower Heritage Fly Musm · Dallas, TXBuilt 1942 · S/N 84-7800 N116SEEberhardt Marilyn Trustee · Danville, CABuilt 1959 · S/N 49-3302 N127VFWoelbing Aviation LLC · Franksville, WIBuilt 1943 · S/N 88-12827 N1284Nelson Aero Service LLC · Aurora, COBuilt 1950 · S/N 12463 N12VTwelve Volt Holdings LLC · Wappingers Falls, NYBuilt 1944 · S/N 197-88 N13372Ageless Aviation Dreams Foundation Inc · Carson City, NVBuilt 1956 · S/N 88-13372 N1364JSnj-2 Corp · Farmingdale, NYBuilt 1951 · S/N 53655 N13FYEastern Stearman Inc Trustee · Leesburg, VABuilt 1942 · S/N 78-6922 N14166National Wasp Wwii Museum · Sweetwater, TXBuilt 1943 · S/N AC41-34166 N150UBrown Jim L · Soddy Daisy, TNS/N 42-44629 N151ATPurkinje Ltd LLC · Wilmington, DES/N 49-3151 N153NAMeyerhoff Jens · Fountain Hills, AZS/N 53-4568 N154CFNelson Craig Martin · Eastsound, WABuilt 1960 · S/N 51985 N157DCExperimental Aircraft Association Inc · Oshkosh, WIBuilt 1949 · S/N 49-3141 N158JZAcv Group LLC · Mckinleyville, CABuilt 1949 · S/N 49-3158 N163TXRyan Good Aviation LLC · Sioux Falls, SDBuilt 1944 · S/N 121-42642 N166WRStokes Field LLC · Mount Vernon, MOS/N 49-3297 N16730Condor Squadron Officers & Airmens Assoc Inc · Van Nuys, CABuilt 1941 · S/N 75-3473 N16JGBohannon James III · Montgomery, TXBuilt 1942 · S/N 26912 N16JVGreatest Generation Naval Museum · Colorado Springs, COBuilt 1949 · S/N 49-3155 N1796Somer Charles Michael · Hillsboro, ORS/N 78-6632 N17TFComanche Warbirds Inc · Houston, TXBuilt 1943 · S/N 4244586 N190FSAnders Gregory · Bellingham, WABuilt 1942 · S/N 42-44709A N1974MAir Cav Helicopters LLC · Wilmington, DES/N 44-81252 N200WEAukes Brian E · Huxley, IABuilt 1942 · S/N 78-6587 N2067JMuszala William P · Tucson, AZS/N 44-81942-1AM N2073YVintage Aircraft LLC · Gilbert, SCBuilt 1941 · S/N 75-3465 N211RFAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1957 · S/N 88-9419 N21VSSchilleci Victor IV · Mandeville, LABuilt 1950 · S/N 168-622 N220BAPalmetto Moon Flight Services LLC · Georgetown, SCS/N 51811 N220SLLewis Samuel K · Chicago, ILBuilt 1951 · S/N 182-648 N22KDMusick Aircraft Corp · Greenwood, MSS/N 88-13072 N22NARothrock Cara · Streator, ILBuilt 1946 · S/N 49-3222 N2441Darznieks John A · Flower Mound, TXBuilt 1951 · S/N 49-3232 N246ZN246z LLC · Seattle, WABuilt 1946 · S/N 88-10676 N257DBKestrel Warbird Experience LLC · Dayton, OHBuilt 1952 · S/N 182-600 N25KPJet Air Inc · Iowa City, IAS/N 49-3336A N25SSHinote Holdings LLC · Saint Charles, MOBuilt 1944 · S/N 85087 N260CFRedneck Fury LLC · Phoenix, AZBuilt 1941 · S/N 49-3536

Back to AD 2005-12-51