Skip to content

Registered aircraft · 219

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-07-03') 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-07-03') 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-07-03')
    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-07-03')
  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-07-03')
  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-07-03')
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.

N103JCAmerican Air Power Heritage Flying Museum · Dallas, TXBuilt 1943 · S/N FC-119 N1094MSartori Luciano · Windermere, FLBuilt 1943 · S/N T43-4470 N1110RCalifornia Flight Museum · Coronado, CABuilt 1942 · S/N T42-3872 N11161Gonzales Donald M · Columbia Station, OHBuilt 1946 · S/N T43-4549 N1129ZTexas Air Museum · Slaton, TXBuilt 1965 · S/N 6 N1131ZTexas Air Museum · Slaton, TXBuilt 1965 · S/N 9 N1132N1941 Historical Aircraft Group Museum DBA · Geneseo, NYBuilt 1942 · S/N FC-27 N1175NHistoric Flights Foundation Corp · Kokomo, INS/N FT-635 N119ECMid Atlantic Air Museum · Reading, PABuilt 1940 · S/N T40-308 N11CMDay Leslie · San Diego, CABuilt 1949 · S/N 9884AE N127MPKelly Michael P · Coldwater, MIBuilt 1943 · S/N T43-5846 N128PTOwens Wilbur · Rch Palos Vrd, CABuilt 1942 · S/N FT735 N129PTTsi Holdco Inc · Virginia Beach, VABuilt 1943 · S/N T43-7230 N130PTMount Glenn W · Modesto, CABuilt 1942 · S/N 325H0 N157PTLaing Malcolm · Lubbock, TXS/N T42-3150 N1594VTennis Gayland L · Bath, MIS/N T434547 N1777Harrington Mark A · West Milford, NJBuilt 1942 · S/N T42-3629 N193ARCorsicana Field Aviation Heritage Foundation · Rice, TXBuilt 1943 · S/N T43-7155 N1941NLone Star Flight Museum · Houston, TXBuilt 1941 · S/N T41-1184 N19PTMoore George C Sr · Fincastle, VAS/N T41-572 N19RHMartin James L · South Bend, INBuilt 1943 · S/N 7583AE N19WRMitchells & Mosquitos LLC · Latham, NYS/N 9504AE N228PTCousineau Paul J · San Clemente, CAS/N 230SL N23PTMulsand Lou A · Knoxville, TNS/N 211 N26PTOld Aeroplane Co LLC · Fort Ogden, FLS/N T43-4513 N3184MMorgan Richard D · Belton, TXBuilt 1943 · S/N 7403AE N323CJKuhnert Michael C · Topping, VABuilt 1943 · S/N T43-5778 N33176Hauck Dennis J · Crawfordsville, INBuilt 1944 · S/N 10424-AE N33870Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1940 · S/N T-40-237 N363AEEichhorn Adrian A · Mclean, VABuilt 1945 · S/N T43-7208 N37425Casa Acquisitions LLC · Winter Haven, FLS/N 4043AE N3925MMid Atlantic Air Museum · Reading, PAS/N HO-155 N39681Price Donald N · Houston, TXS/N FV133 N40265American Airpower Heritage Flying Museum · Dallas, TXBuilt 1941 · S/N T41562 N4119AManning Philip J · Melbourne, FLBuilt 1941 · S/N T41-1048 N439EWImlay Ryan E · Livermore, CABuilt 1943 · S/N T43-4498 N46197Fagen Roland J · Granite Falls, MNS/N T43-7272 N46199Hagerstown Aviation Museum Inc · Hagerstown, MDBuilt 1944 · S/N T43-7274 N462XPThomas Robert S · Caddo Mills, TXS/N T41-730 N46389Boggs Wayne G · Tampa, FLBuilt 1943 · S/N T43-5311 N464BCCaldwell Collection Inc · Oklahoma City, OKBuilt 1942 · S/N 253 N464ZMManning Mark B · Bridport, VTS/N T42-4047 N46836Planes Of Fame Air Museum · Chino, CAS/N FV703 N46876American Airpower Heritage Flying Museum · Dallas, TXBuilt 1942 · S/N T421957 N46881Riffle Brian W · Auburn, WABuilt 1943 · S/N T435426 N47015Mohr Charles F · Buffalo, NYRegistration revokedBuilt 1943 · S/N 4435792 N47117Bauer Aviation LLC · Reese, MIBuilt 1943 · S/N T43-5397 N47154Williamson Rolla Charles Jr · East Falmouth, MARegistration revokedBuilt 1943 · S/N 7283AE N47158Jorgensen Jeremiah D · Elizabethtown, KYBuilt 1943 · S/N T43-7428 N47279Emmons Donald R · Flint, MIRegistration revokedBuilt 1940 · S/N T40392

Back to AD 47-07-03