Skip to content

Ab Prop Plane I LLC

Registered aircraft · 39

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 = 'AB PROP PLANE I LLC' OR list_contains(g.other_registrant_names, 'AB PROP PLANE I 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 = 'AB PROP PLANE I LLC' OR list_contains(g.other_registrant_names, 'AB PROP PLANE I 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 = 'AB PROP PLANE I LLC' OR list_contains(g.other_registrant_names, 'AB PROP PLANE I 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.

N102USCostruzioni Aeronautiche Tecna P-MENTOR · S/N 1120/USBuilt 2024 · Metairie, LA N112LGPiper PA-28-181 · S/N 2881907Built 2025 · Metairie, LA N1449CCessna 172S · S/N 172S9892Built 2005 · Metairie, LA N184LGPiper PA-28-181 · S/N 2881908Metairie, LA N210TDCostruzioni Aeronautiche Tecna P2010 TDI · S/N 145/USBuilt 2021 · Metairie, LA N225SFTextron 172S · S/N 172S13441Built 2025 · Metairie, LA N246SFTextron 172S · S/N 172S13442Built 2025 · Metairie, LA N254SFTextron 172S · S/N 172S13401Built 2025 · Metairie, LA N256SFTextron 172S · S/N 172S13403Built 2025 · Metairie, LA N259SFTextron 172S · S/N 172S13404Built 2025 · Metairie, LA N263SFTextron 172S · S/N 172S13406Built 2025 · Metairie, LA N264SFTextron 172S · S/N 172S13407Built 2025 · Metairie, LA N265SFTextron 172S · S/N 172S13409Built 2025 · Metairie, LA N277LGPiper PA-28-181 · S/N 2881909Built 2025 · Metairie, LA N278UACostruzioni Aeronautiche Tecna P2010 · S/N 278/USBuilt 2024 · Metairie, LA N287UACostruzioni Aeronautiche Tecna P2010 TDI · S/N 287/USBuilt 2024 · Metairie, LA N308KFCostruzioni Aeronautiche Tecna P2010 · S/N 296/USBuilt 2024 · Metairie, LA N386USCostruzioni Aeronautiche Tecna P2006T · S/N 386/USBuilt 2023 · Metairie, LA N398UACostruzioni Aeronautiche Tecna P2006T · S/N 398/USBuilt 2023 · Metairie, LA N436SCPiper PA-44-180 · S/N 4496362Built 2014 · Metairie, LA N437SCPiper PA-44-180 · S/N 4496363Built 2014 · Metairie, LA N458SCPiper PA-44-180 · S/N 4496490Built 2019 · Metairie, LA N459SCPiper PA-44-180 · S/N 4496492Built 2019 · Metairie, LA N512VACostruzioni Aeronautiche Tecna P2010 · S/N 299/USBuilt 2024 · Metairie, LA N565LGPiper PA-28-181 · S/N 2881905Built 2025 · Metairie, LA N630CBCostruzioni Aeronautiche Tecna P2006T · S/N 372/USBuilt 2022 · Metairie, LA N658LGPiper PA-28-181 · S/N 2881906Built 2025 · Metairie, LA N846AAPiper PA-28-181 · S/N 2881846Built 2025 · Metairie, LA N848AAPiper PA-28-181 · S/N 2881848Built 2025 · Metairie, LA N849AAPiper PA-28-181 · S/N 2881849Built 2025 · Metairie, LA N851AAPiper PA-28-181 · S/N 2881850Built 2025 · Metairie, LA N853AAPiper PA-28-181 · S/N 28010044Built 2026 · Metairie, LA N902USCostruzioni Aeronautiche Tecna P2010 TDI · S/N 290/USBuilt 2024 · Metairie, LA N933SCPiper PA-28-181 · S/N 2881873Built 2025 · Metairie, LA N937SCPiper PA-28-181 · S/N 2881874Built 2025 · Metairie, LA N955SCPiper PA-28-181 · S/N 2881875Built 2025 · Metairie, LA N973HACessna 172S · S/N 172S9975Built 2005 · Metairie, LA N977SCPiper PA-28-181 · S/N 2881876Built 2025 · Metairie, LA N990SCPiper PA-28-181 · S/N 2881877Built 2025 · Metairie, LA

Back to Ab Prop Plane I LLC