Yingling Aircraft Inc
Earlier aircraft under this name · 38
Cancelled registrations that named this owner when they ended, newest first.
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'YINGLING AIRCRAFT INC' OR list_contains(d.other_registrant_names, 'YINGLING AIRCRAFT INC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'YINGLING AIRCRAFT INC' OR list_contains(d.other_registrant_names, 'YINGLING AIRCRAFT INC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
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.
N53443Cessna 172S · S/N 172S9370N1171Cessna 208B · S/N 208B0884N63151Cessna 172P · S/N 17275397N415MABeech C90 · S/N LJ-900N6217NCessna 182R · S/N 18267800N6571YCessna T210N · S/N 21064443N11WCPiper PA-31T · S/N 31T8020033N4876XCessna U206G · S/N U20605560N9464UCessna 150M · S/N 15078412N7663QCessna T310Q · S/N 310Q-0442N35935Cessna U206F · S/N U20602810N6096FCessna 182P · S/N 18264111N2758UCessna 172D · S/N 17250358N4005LCessna 421 · S/N 421-0005N5009UCessna 206 · S/N 2060009N70222Cessna A185E · S/N 18502066N389KSCessna 310N · S/N 310N-0047N5883ACessna 172 · S/N 28483N7558QCessna T310Q · S/N 310Q-0058N2327YCessna 177 · S/N 17700127N4228LCessna 172G · S/N 17254297N7124XCessna 150 · S/N 15059224N794NCessna 180A · S/N 32763N5402ECessna 182A · S/N 51461N4982ACessna 180 · S/N 32379N4608ACessna 180 · S/N 32206N2606GCessna 182 · S/N 51906N5637BCessna 182 · S/N 33637N6228ACessna 182 · S/N 33028N7455MCessna 175 · S/N 55755N180WCessna 180 · S/N 30910N3604DCessna 310 · S/N 35304N73028Cessna 140 · S/N 10233N5692CCessna 140A · S/N 15648N1540CCessna 180 · S/N 30240N8021ACessna 170B · S/N 20873N598CStinson 108-3 · S/N 108-3598N3045VBeech 35 · S/N D-458
Back to Yingling Aircraft Inc