Registered aircraft · 229

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:81-14-10') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-14-10') 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:81-14-10')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-14-10')
  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:81-14-10')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-14-10')
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 N104DCBudde-Jones Kathryn M · Celebration, FLBuilt 1949 · S/N 49-3392 N1054MYaggie Allen R · Wahpeton, NDBuilt 1950 · S/N 49-3044 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 N116SEEberhardt Marilyn Trustee · Danville, CABuilt 1959 · S/N 49-3302 N1284Nelson Aero Service LLC · Aurora, COBuilt 1950 · S/N 12463 N12VTwelve Volt Holdings LLC · Wappingers Falls, NYBuilt 1944 · S/N 197-88 N1364JSnj-2 Corp · Farmingdale, NYBuilt 1951 · S/N 53655 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 N16JVGreatest Generation Naval Museum · Colorado Springs, COBuilt 1949 · S/N 49-3155 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 N2067JMuszala William P · Tucson, AZS/N 44-81942-1AM 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 N22NARothrock Cara · Streator, ILBuilt 1946 · S/N 49-3222 N2441Darznieks John A · Flower Mound, TXBuilt 1951 · S/N 49-3232 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 N26862American Airpower Museum · Farmingdale, NYS/N 90699 N27409Qrd Equipment Corp · Dover, DEBuilt 1949 · S/N 49-3829 N2761AMaier Diane K · Underwood, WABuilt 1952 · S/N 197011 N276RBB & B Warbird Aviation Inc · Haddon Heights, NJBuilt 1940 · S/N 91008 N279SQBrutlag Farms Inc · Wendell, MNBuilt 1950 · S/N 50-1279 N2805GSciog Kenneth R · Grand Island, NYS/N 49-3139A N2813GShacklette Donald L · Brandenburg, KYBuilt 1949 · S/N 49-2910 N2831DBowlin & Associates Inc · Clayton, GABuilt 1958 · S/N 53-4577 N2834DMuseum Of Flight Foundation · Seattle, WABuilt 1944 · S/N 44-81753 N2897GSix Cat Racing Inc · Tulelake, CABuilt 1959 · S/N 49-3492 N29678Osprey Aircraft LLC · De Leon Springs, FLS/N 51999 N2983Lindrooth Steven · Perkasie, PABuilt 2002 · S/N 42-86272X N29910Smith Robert D · Grapevine, TXBuilt 1942 · S/N 88-13581 N29939Wiley Sanders Truck Lines Inc · Troy, ALBuilt 1943 · S/N 49-3034 N29941Besterveld Paul Z · Austin, TXBuilt 1943 · S/N 52026

Back to AD 81-14-10