Leonard Steven E
Registered aircraft · 69
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 = 'LEONARD STEVEN E' OR list_contains(g.other_registrant_names, 'LEONARD STEVEN E') 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 = 'LEONARD STEVEN E' OR list_contains(g.other_registrant_names, 'LEONARD STEVEN E') 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.
N111NDLaister Sailplane LP-15 · S/N N4N1166HSegelflugzeugbau A Neukom ELFE 17 · S/N 32N1193Flug & Fahrzeugwerke FFA HBV-DIAMANT 16.5 · S/N 012N1194Schempp-Hirth CIRRUS · S/N 4N11KBGlaser-Dirks DG-500M · S/N 6-79 M26N11LEFlug & Fahrzeugwerke FFA HBV-DIAMANT 16.5 · S/N 013N124ZSSchleicher AS-W12 · S/N 12015XN12JHGlasflugel KESTREL · S/N 31N1353ZApplebay Sailplanes ZUNI II · S/N 28N1372Schreder HP-14T · S/N 70N15BLHager/Hager RS 15 GLIDER · S/N 15-32N1610CSlingsby DART T.51/17R · S/N 1610N165DGlasflugel 604 · S/N 3N16NCNiemi L A/Clark E G JUNCO · S/N 12N1791Riva-Schreder HP-13 · S/N 74N20TJConcept Sailplane Mfg C-70 · S/N 20N240NXApparatebau Nabern FS 24 PHONIX T · S/N 406N24HCGlasflugel MOSQUITO · S/N 54N25000Briegleb-Nichols BGN 112 · S/N 1N25001Leonard ANNEBULA · S/N 1N25521Bates DUSTER BJ1B · S/N 147FFBN295WWWebster William J BJ-1B DUSTER · S/N 295N303SSGlasflugel MOSQUITO · S/N 92N3083Schleicher KA 6 E · S/N 4161N34ZSSchempp-Hirth NIMBUS 3 · S/N 18N354SRFlug & Fahrzeugwerke FFA HBV-DIAMANT 16.5 · S/N 039N366WJiran FJ-1 · S/N 1N4029ASchleicher KA 6 CR · S/N 944N4046XNeukom A ELFE MN-R · S/N 03N412SSchleicher AS-W12 · S/N 12012N435ACAS+ AC 4 · S/N 035N470LYOlympia 1 · S/N 9N4736GSchreder HP-14 · S/N 1N4778GSchreder HP-11 · S/N 6N50ARGlasflugel BS-1 · S/N 12N511MRolladen-Schneider LS-6 · S/N 6037N555WGGlasflugel MOSQUITO · S/N 77N5681Keim GLASFLUEGEL · S/N 16N57LGlasflugel 604 · S/N 8N59LLGlasflugel KESTREL · S/N 32N604VPGlasflugel 604 · S/N 7N609LZSzybowcowy Zaklad Doswiadczaln SZD-42-2 JANTAR 2B · S/N B940N614RPPflieger HP-14T AIRMATE · S/N 48N6159Bliss TERN 17M · S/N WVB/WTM-11-70N62301Glasflugel 604 · S/N 281N63SLSlingsby TYPE T-50 SKYLARK 4 · S/N 1365N644CACentrair 101 · S/N 101 090N6501DSchleicher KA 6 CR · S/N 652N661NPreiss RHJ-9 · S/N 001N6660DSchleicher K 8 B · S/N 136
Back to Leonard Steven E