Weeks Kermit A
Registered aircraft · 82
Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'WEEKS KERMIT A' OR list_contains(g.other_registrant_names, 'WEEKS KERMIT A') ORDER BY g.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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'WEEKS KERMIT A' OR list_contains(g.other_registrant_names, 'WEEKS KERMIT A') ORDER BY g.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.
N102BLBuhl LA-1 · S/N 102N105WLockheed VEGA 5C · S/N 72N106EPSeversky P-35A · S/N 282-11N108KWMesserschmitt ME 108 TAIFUN · S/N 1914N10967Curtiss Wright JR CW1 · S/N 1145N11170Stinson SM-6000-B · S/N 5023N111VASikorsky S-55 · S/N 55433N1204North American P-51C · S/N 103-26385N1267BPitcairn PA-18 · S/N G-65N147DPBell 47G · S/N 1685N1606Nord STAMPE SV4C · S/N 190N174VCurtiss Wright TRAVEL AIR B-4000 · S/N 1365N181BUMoravan ZLIN 381 · S/N 461N1913BKermit A Weeks WEEKS/BENOIST · S/N TJ-1N19175Vintage Aviator Limited The ALBATROS DVA-1 · S/N 1267N1917TThomas Morse Scout S4C · S/N 633N1943JNorth American B-25N · S/N 43-28059AN1944ADouglas DC3C-S1C3G · S/N 19677N19RXCurtiss Wright 19R · S/N 19R-20N2101Benjamin Delmar R GEE BEE R-2 · S/N GB-02N2145Orenco BIPLANE · S/N 45N222FMGrumman FM-2 · S/N 5975N229VTGloster METEOR F4 · S/N VT229N230MSMorane-Saulnier 230 · S/N 1049N2404Curtiss JN4D · S/N 5360N240GGeneral GENAIRCO · S/N 17N255YTurner BROWN RACER (REP)B-2 · S/N T-2N269ZWFred Murrin FOKKER D-7 · S/N FM-15N26KWGrumman F3F-2 · S/N 1028N2825DStandard J-1 · S/N 1582N282DWDewoitine D26 · S/N 10853N28VBorn Again Restorations S-38B · S/N B414-20N300KWWeeks Kermit WEEKS SOLUTION S1-WS · S/N 001N30425Polikarpov I-16 TYPE 24 · S/N 2421645N30KWWeeks DER JAGER D-IX · S/N 003N3182GTerteling AVRO 504K · S/N B3182N3215MMains Donald Lee GEE BEE Y · S/N DM002N349NAmerican Aeronautical MARCHETTI S-56-B · S/N 12N358DHCentury DH-4 · S/N MAILPLANEN3931YNorth American AT-6 · S/N 49-3311N3936AConsolidated Vultee PBY-5A · S/N 33966N39401Douglas B-26C · S/N 41-39401N40BJBucker BU-133 · S/N 4N4260CBristol-Blenheim BOLINGBROKE MK IV · S/N 11-880-203N4301UAntonov AN-2 · S/N 8331N4302RAntonov AN-2 · S/N 8339N4311ZBristol-Blenheim BOLINGBROKE MK IV · S/N 11-880-202N434DHCentury DH-4 · S/N WWIN436WRCommonwealth CA-16 MK 3 · S/N A20-704N440Sikorsky S-43H · S/N 4327
Back to Weeks Kermit A