Skip to content

Registered aircraft · 67

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:46-14-02') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:46-14-02') 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:46-14-02')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:46-14-02')
  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:46-14-02')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:46-14-02')
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 N1132N1941 Historical Aircraft Group Museum DBA · Geneseo, NYBuilt 1942 · S/N FC-27 N1175NHistoric Flights Foundation Corp · Kokomo, INS/N FT-635 N128PTOwens Wilbur · Rch Palos Vrd, CABuilt 1942 · S/N FT735 N26PTOld Aeroplane Co LLC · Fort Ogden, FLS/N T43-4513 N39681Price Donald N · Houston, TXS/N FV133 N40265American Airpower Heritage Flying Museum · Dallas, TXBuilt 1941 · S/N T41562 N46389Boggs Wayne G · Tampa, FLBuilt 1943 · S/N T43-5311 N464ZMManning Mark B · Bridport, VTS/N T42-4047 N46836Planes Of Fame Air Museum · Chino, CAS/N FV703 N4732GAmerican Airpower Heritage Flying Mu · Dallas, TXBuilt 1965 · S/N 10846 N48841Riffle George W · Auburn, WABuilt 1941 · S/N T41-997 N49462Mertesdorf John P · Nicollet, MNBuilt 1943 · S/N T43-4340 N49481Fleeman Joseph R · Lawrenceburg, TNBuilt 1942 · S/N FV162 N50175Obowa Denis J · Fergus Falls, MNBuilt 1943 · S/N T43-5301 N51090Butler County Warbirds Inc · Middletown, OHBuilt 1943 · S/N T43-5048 N519SHAmerican Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1943 · S/N T-435954 N52079American Airpower Heritage Flying Museum · Dallas, TXS/N FT-782 N526PTKyler Chris K · Meridian, MSBuilt 1943 · S/N FC-47 N53279Leverich James E · Pampa, TXBuilt 1943 · S/N T43-5589 N54254Craig Robert A · West Chester, PABuilt 1941 · S/N T-42-1831 N5519NAmerican Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1944 · S/N FC-18 N55406Kappler Christian · Fayetteville, WVBuilt 1942 · S/N T42-1394 N58108Hamilton Robert J · Perry, GABuilt 1943 · S/N FC-179 N58749Mendenhall James W Trustee · Anchorage, AKS/N T42-4191 N58799Egmond Aircraft LLC · Lewes, DEBuilt 1943 · S/N FV-154 N58810Texas Air Museum · Slaton, TXS/N FT825 N58894Vintage Flying Machines Inc · Huntington, INBuilt 1946 · S/N FT-737 N60385Henderson Douglas T · Mulino, ORBuilt 1943 · S/N FV-454 N60535American Airpower Heritage Fly Musm · Dallas, TXBuilt 1945 · S/N FX-146 N6072CAmerican Airpower Heritage Fly Musm · Dallas, TXBuilt 1954 · S/N 42-65935 N6109PNichols Charles F Trustee · Baldwin Park, CAS/N MAN FC 110 N619PTKirk James H · Leavenworth, KSS/N FC-120 N63568Fairchild Aircraft LLC · Dover, DEBuilt 1943 · S/N T43-4499 N6587DCanterbury Greg · Daniel Island, SCS/N FT-643 N67523Crnic Paul · Chesterfield, MOBuilt 1943 · S/N FV152 N67616Inzana Anthony F II · Hughson, CABuilt 1943 · S/N FV123 N67878R&G Aero LLC · Wilmington, DEBuilt 1942 · S/N T-42-4171 N68150Mehrer Fritz J · El Cajon, CABuilt 1943 · S/N T43-4496 N68210Imlay Ryan E · Livermore, CAS/N FA443 N69167Chico Air Museum · Chico, CABuilt 1943 · S/N FV-342 N69243Coffman Robert P · Bigfork, MTS/N T424194 N69256Reichert John A · Rehoboth Beach, DEBuilt 1944 · S/N FV-257 N69262Planes Of Fame Air Museum · Chino, CABuilt 1943 · S/N FT-683 N69590Easy Air LLC · Wilmington, DEBuilt 1942 · S/N T42-4187 N73327Harris Kenneth L · Greeley, COBuilt 1946 · S/N FV-664 N73521American Airpower Heritage Flying Museum · Dallas, TXS/N T43-4450 N73529Shokoui Kourosh C · Panama City, FLBuilt 1943 · S/N T43-4456 N74621Military Aviation Museum · Virginia Beach, VABuilt 1959 · S/N T43-4503

Back to AD 46-14-02