Ab Prop Plane II LLC
Registered aircraft · 58
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 = 'AB PROP PLANE II LLC' OR list_contains(g.other_registrant_names, 'AB PROP PLANE II 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 II LLC' OR list_contains(g.other_registrant_names, 'AB PROP PLANE II 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.
N101TFTextron 172S · S/N 172S12710N138UDCessna 172S · S/N 172S11487N139UDCessna 172S · S/N 172S11488N13HNTextron 172S · S/N 172S13255N140UDCessna 172S · S/N 172S11489N142UDCessna 172S · S/N 172S11490N15ANTextron 172S · S/N 172S13258N20BQTextron 172S · S/N 172S13216N2105XTextron 172S · S/N 172S12585N24BQTextron 172S · S/N 172S13217N25BQTextron 172S · S/N 172S13218N26BQTextron 172S · S/N 172S13219N26LPTextron 172S · S/N 172S13252N28MKTextron 172S · S/N 172S13269N28PKTextron 172S · S/N 172S13253N294RWTextron 172S · S/N 172S12898N316DCTextron 172S · S/N 172S12899N328FATextron 172S · S/N 172S13220N37SDTextron 172S · S/N 172S13250N38RATextron 172S · S/N 172S13272N38SBTextron 172S · S/N 172S13261N407EBCessna 172S · S/N 172S11438N408EPCessna 172S · S/N 172S11439N427CRCessna 172S · S/N 172S11450N431CRCessna 172S · S/N 172S11454N437EPCessna 172S · S/N 172S11605N454AGCessna 172S · S/N 172S11588N463AGCessna 172S · S/N 172S11597N561DTextron 172S · S/N 172S12066N567SPTextron 172S · S/N 172S12705N597DTextron 172S · S/N 172S12068N59TWTextron 172S · S/N 172S13249N628CTTextron 172S · S/N 172S12897N636EMTextron 172S · S/N 172S12852N673JHTextron 172S · S/N 172S12900N73CHTextron 172S · S/N 172S13234N740DTextron 172S · S/N 172S12070N786FATextron 172S · S/N 172S13163N787FATextron 172S · S/N 172S13164N788FATextron 172S · S/N 172S13166N789FATextron 172S · S/N 172S13167N790FATextron 172S · S/N 172S13169N791FATextron 172S · S/N 172S13170N792FATextron 172S · S/N 172S13172N793FATextron 172S · S/N 172S13173N794FATextron 172S · S/N 172S13174N795FATextron 172S · S/N 172S13176N820DTextron 172S · S/N 172S12565N823DTextron 172S · S/N 172S12566N834DTextron 172S · S/N 172S12567
Back to Ab Prop Plane II LLC