Registered aircraft · 16

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 = 'ATP TAA LLC' OR list_contains(g.other_registrant_names, 'ATP TAA 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 = 'ATP TAA LLC' OR list_contains(g.other_registrant_names, 'ATP TAA 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 = 'ATP TAA LLC' OR list_contains(g.other_registrant_names, 'ATP TAA 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.

N311GPiper PA-28-181 · S/N 2881422Wilmington, DE N337GPiper PA-28-181 · S/N 2881424Built 2020 · Wilmington, DE N358GPiper PA-28-181 · S/N 2881428Built 2020 · Wilmington, DE N381GPiper PA-28-181 · S/N 2881429Built 2020 · Wilmington, DE N384GPiper PA-28-181 · S/N 2881430Built 2020 · Wilmington, DE N471TAPiper PA-28-181 · S/N 2881313Wilmington, DE N472TAPiper PA-28-181 · S/N 2881314Wilmington, DE N473TAPiper PA-28-181 · S/N 2881315Wilmington, DE N474TAPiper PA-28-181 · S/N 2881316Wilmington, DE N475TAPiper PA-28-181 · S/N 2881317Wilmington, DE N476TAPiper PA-28-181 · S/N 2881318Wilmington, DE N839ATPiper PA-44-180 · S/N 4496565Built 2023 · Wilmington, DE N840ATPiper PA-44-180 · S/N 4496566Built 2023 · Wilmington, DE N849ATPiper PA-44-180 · S/N 4496567Built 2023 · Wilmington, DE N850ATPiper PA-44-180 · S/N 4496568Built 2023 · Wilmington, DE N851ATPiper PA-44-180 · S/N 4496569Built 2023 · Wilmington, DE

Back to Atp Taa LLC