Denton, TX
Cancelled registrations · 166
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 = 'DENTON' 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 = 'DENTON' 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.
N94802Cessna 152 · S/N 15285791N33681Piper PA-32-300 · S/N 32-7540111N69103Cessna 152 · S/N 15282483N987BTCessna 172R · S/N 17280452N6263QCessna 310Q · S/N 310Q0524N1482WBell 206B · S/N 412N4546TPiper PA-34-200 · S/N 34-7250130N4998LPiper PA-28-140 · S/N 28-7525186N99EFCessna 414A · S/N 414A0666N8248VCessna A185F · S/N 18502722N1080BMooney M20A · S/N 1306N88JGBucker-Jungman 131 · S/N 27N111DSBell 222U · S/N 47554N64936Cessna 152 · S/N 15281485N66450Cessna 150M · S/N 15076057N9419CPiper PA-28-161 · S/N 28-7816474N107EHPiper PA-28-140 · S/N 28-7525057N6870GCessna 150L · S/N 15072370N7390YPiper PA-30 · S/N 30-446N2511PPiper PA-22-150 · S/N 22-2873N150GTCessna 401B · S/N 401B0040N2488HEngineering & Research ERCOUPE 415-C · S/N 3113N76SVBellanca 17-30A · S/N 76-30810N400TFIsrael Aircraft Industries 1124 · S/N 279N900JFAmerican Champion 8KCAB · S/N 871-2000N400BKPiper PA-24-400 · S/N 26-115N402GRCessna 402C · S/N 402C0035N6013JBell OH-58A · S/N 70-15545N99470Ercoupe 415-D · S/N 2093N4612Miller Monte PIETENPOL AIR-CAMPER · S/N RW420N221NCBeech B90 · S/N LJ-393N80QCessna 402B · S/N 402B1384N9022DCessna 305A · S/N 21311N113JKKearns Homer Charles III VANS RV-8 · S/N 80271N710WTCessna 402A · S/N 402A-0094N667NABeech 200 · S/N BB-667N334Larson Stuart E JAVELIN V6STOL · S/N 001N21LLPiper PA-28-235 · S/N 2811235N81110Grumman American Avn. AA-5B · S/N AA5B0432N57GDDeaton Gene G JUNGSTER-I · S/N 7201N718RSAlon A2 · S/N A82N4268QRaven S-60A · S/N S60A298N1408HPiper PA-28-181 · S/N 287790311N72FDSIAI Marchetti F.260C · S/N 729N7414VMooney M20F · S/N 22-1207N2105XCessna 337 · S/N 337-0005N4238JPiper PA-28-140 · S/N 28-22590N15983Piper PA-34-200 · S/N 34-7350115N79047Cessna 172K · S/N 17257840N5887LGrumman American Avn. AA-5 · S/N AA5-0087
Back to Denton, TX