Irving, TX
Cancelled registrations · 184
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_state = 'TX' AND d.registrant_city = 'IRVING' 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_state = 'TX' AND d.registrant_city = 'IRVING' 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.
N428UBBell Helicopter Textron Canada 429 · S/N 57017N22633Cessna 150H · S/N 15068416N3103TCessna 177 · S/N 17700403N582RDDarling Robert Lynn SKYTWISTER · S/N BSM/ 582 LC-01N2771YBeech 95 · S/N TD-133N33517Schweizer SGU-1-19 · S/N 4N94173Engineering & Research ERCOUPE 415-C · S/N 1496N777TEDassault-Breguet MYSTERE FALCON 200 · S/N 500N4925ESikorsky S-51 · S/N 232N4302DBeech D-50 · S/N DH-59N37469Bell 206B · S/N 2305N453LBBell Helicopter Textron Canada 429 · S/N 57061N48327Fairchild M-62A · S/N 7123AEN3709XAero Commander 100-180 · S/N 5010N3710HErcoupe 415-C · S/N 4335N1791WBeech E-55 · S/N TE-891N5364Grumman G-164A · S/N 645N5347KRyan NAVION B · S/N NAV-4-2247-BN54052Briegleb BG-12B · S/N 115N18027Cessna 150L · S/N 15073743N459XBBell Helicopter Textron Canada 412EP · S/N 36586N428VBBell Helicopter Textron Canada 429 · S/N 57016N238WTaft Malcolm J SR GLASTAR · S/N 05110N420DPBell Helicopter Textron Canada 412EP · S/N 36561N7ZYCessna 182A · S/N 34228N392KMBell Helicopter Textron Canada 429 · S/N 57008N397CFBell Helicopter Textron Canada 412EP · S/N 36537N397WBBell Helicopter Textron Canada 412EP · S/N 36538N455MTBell Helicopter Textron Canada 407 · S/N 54000N357PBBell Helicopter Textron Canada 412EP · S/N 36503N56266Bell Helicopter Textron Canada 407 · S/N 53800N56157Bell Helicopter Textron Canada 430 · S/N 49129N7899LBeech V35 · S/N D-8311N8533YBell Helicopter Textron Canada 430 · S/N 49125N8510EBell Helicopter Textron Canada 412EP · S/N 36439N8531QBell Helicopter Textron Canada 430 · S/N 49124N50829Bell 407 · S/N 53746N7512RBell Helicopter Textron Canada 206L-4 · S/N 52337N2073VBell 407 · S/N 53698N1035UBell 430 · S/N 49116N70871Bell 407 · S/N 53677N10350Bell 430 · S/N 49115N8097FTaft Malcolm J SR RV-6A · S/N 24446N6524VVenture LT Acft Resources T-211 · S/N 106N4203GBell 430 · S/N 49106N42838Bell 206B · S/N 4585N27VSSaladino Vince O SEAREY · S/N KM27N406CTReims Aviation S A F406 · S/N 0061N34TZBopp Timothy C LANCAIR 235 · S/N 008N6084ZBell 427 · S/N 56021
Back to Irving, TX