Airplane Factory Inc
Registered aircraft · 49
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 = 'AIRPLANE FACTORY INC' OR list_contains(g.other_registrant_names, 'AIRPLANE FACTORY INC') 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 = 'AIRPLANE FACTORY INC' OR list_contains(g.other_registrant_names, 'AIRPLANE FACTORY INC') 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.
N181KMSean Mullett SLING TSI · S/N 682SQN212HWJoseph Keenan SLING HW · S/N 131GQN2151BSling SLING LSA · S/N 327N221YZYuriy Chanba SLING TSI · S/N 694SQN248FSSling SLING LSA · S/N 405AN262WTChad W Macdonald SLING TSI · S/N 713SQN265LDSling SLING LSA · S/N 377AN299PBPeter Herschel Breen SLING TSI · S/N 708SQN307SWSling SLING LSA · S/N 403AN326CHChris Haarhoff SLING TSI · S/N 459SKN329SHMichael Salmen SLING HW · S/N 081GQN444EBSling SLING LSA · S/N 396AN470RBSling SLING LSA · S/N 411AN532ANSling SLING LSA · S/N 400AN543WBSling SLING LSA · S/N 419ANon-citizen corporation, flight hours not reportedN545BCSling SLING LSA · S/N 410AN5767GSling SLING LSA · S/N 334N588ADSling SLING LSA · S/N 384AN619HWAirplane Factory SLING TSI HW · S/N 008GKN627GHSling SLING LSA · S/N 486AN638SSSling SLING LSA · S/N 380AN656HWDaniel Moody SLING HW · S/N 088GQN665SHSling SLING LSA · S/N 481AN669JPJuan-Peter Schulze SLING HW · S/N 005KN704APWayne A Puckett SLING TSI · S/N 710SQN711VHSteven Vedral SLING TSI · S/N 393SKN727HRSling SLING LSA · S/N 399AN732ZYSling SLING LSA · S/N 407ANon-citizen corporation, flight hours not reportedN737PTSling SLING LSA · S/N 406ANon-citizen corporation, flight hours not reportedN747PDArthur Peter Rozum SLING TSI · S/N 740SQN775AMSling SLING LSA · S/N 417AN7878SSling SLING LSA · S/N 392AN799TRSling SLING LSA · S/N 397AN805AZSling SLING LSA · S/N 379AN814TATom Joas SLING TSI · S/N 739SQN81BVSling SLING LSA · S/N 395AN820DMSling SLING LSA · S/N 376AN821FRSling SLING LSA · S/N 420ANon-citizen corporation, flight hours not reportedN864SLSling SLING LSA · S/N 330Non-citizen corporation, flight hours not reportedN866SLSling SLING LSA · S/N 337Non-citizen corporation, flight hours not reportedN916RRon Jones SLING HW · S/N 121GQN916TSAirplane Factory SLING TSI · S/N 454SKN928MPSling SLING LSA · S/N 383AN93QMSling SLING LSA · S/N 408AN947HHSling SLING LSA · S/N 398ANon-citizen corporation, flight hours not reportedN954FCSling SLING LSA · S/N 487AN970CFSling SLING LSA · S/N 378AN987MTSling SLING LSA · S/N 414AN991ALSling SLING LSA · S/N 382A
Back to Airplane Factory Inc