Registered aircraft · 21

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

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 = 'KELLEY AIRCRAFT LLC' OR list_contains(g.other_registrant_names, 'KELLEY AIRCRAFT LLC') ORDER BY g.n_number

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 = 'KELLEY AIRCRAFT LLC' OR list_contains(g.other_registrant_names, 'KELLEY AIRCRAFT LLC')
  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 = 'KELLEY AIRCRAFT LLC' OR list_contains(g.other_registrant_names, 'KELLEY AIRCRAFT LLC')
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.

N12600Cessna 172M · S/N 17262103Built 1973 · Weyers Cave, VA N12651Cessna 172M · S/N 17262146Built 1973 · Weyers Cave, VA N13405Cessna 172M · S/N 17262734Built 1973 · Weyers Cave, VA N13644Cessna 172M · S/N 17262904Built 1974 · Weyers Cave, VA N20157Cessna 172M · S/N 17261053Built 1972 · Weyers Cave, VA N20376Cessna 172M · S/N 17261237Built 1972 · Weyers Cave, VA N2858QCessna 172L · S/N 17259858Built 1971 · Weyers Cave, VA N5409JCessna 172N · S/N 17273782Built 1980 · Weyers Cave, VA N59VLCessna 172L · S/N 17259905Built 1971 · Weyers Cave, VA N727RCCessna 172M · S/N 17263887Built 1974 · Weyers Cave, VA N733FCCessna 172N · S/N 17268253Built 1976 · Weyers Cave, VA N733TXCessna 172N · S/N 17268545Built 1977 · Weyers Cave, VA N7540GCessna 172L · S/N 17259240Built 1970 · Weyers Cave, VA N7575GCessna 172L · S/N 17259275Built 1970 · Weyers Cave, VA N757BBCessna 152 · S/N 15279600Built 1977 · Weyers Cave, VA N7747GCessna 172L · S/N 17259447Built 1970 · Weyers Cave, VA N7781GCessna 172L · S/N 17259481Built 1970 · Weyers Cave, VA N888CMCessna 172M · S/N 17267424Built 1976 · Weyers Cave, VA N8995UCessna 150M · S/N 15078045Built 1976 · Weyers Cave, VA N9630QCessna 172M · S/N 17265714Built 1975 · Weyers Cave, VA N9796VCessna 172M · S/N 17264506Weyers Cave, VA

Back to Kelley Aircraft LLC