Nicholas Services LLC
Registered aircraft · 25
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 = 'NICHOLAS SERVICES LLC' OR list_contains(g.other_registrant_names, 'NICHOLAS SERVICES 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 = 'NICHOLAS SERVICES LLC' OR list_contains(g.other_registrant_names, 'NICHOLAS SERVICES 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.
N287NTextron 525B · S/N 525B0610N316NEmbraer Executive EMB-500 · S/N 50000280N317NEmbraer Executive EMB-505 · S/N 50500280N328NTextron 680A · S/N 680A0008N374NEmbraer Executive EMB-500 · S/N 50000311N377NEmbraer Executive EMB-505 · S/N 50500199N412NEmbraer Executive EMB-505 · S/N 50500454N419NEmbraer Executive EMB-505 · S/N 50500583N432NEmbraer Executive EMB-505 · S/N 50500569N433NEmbraer Executive EMB-505 · S/N 50500534N435NEmbraer Executive EMB-505 · S/N 50500655N516NEmbraer Executive EMB-505 · S/N 50500397N529NEmbraer Executive EMB-505 · S/N 50500761N572NEmbraer Executive EMB-505 · S/N 50500776N622NBombardier BD-100-1A10 · S/N 20286N623NBombardier BD-100-1A10 · S/N 20833N633NBombardier BD-100-1A10 · S/N 20860N715NTextron 680A · S/N 680A0012N724NTextron 680A · S/N 680A0203N738NTextron 680A · S/N 680A0244N807NEmbraer Executive EMB-505 · S/N 50500504N810NEmbraer Executive EMB-505 · S/N 50500602N814NEmbraer Executive EMB-505 · S/N 50500455N839NEmbraer Executive EMB-505 · S/N 50500506N923NGulfstream Aerospace GVII-G600 · S/N 73060
Back to Nicholas Services LLC