Atlanta, GA
Cancelled registrations · 1,436
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 = 'GA' AND d.registrant_city = 'ATLANTA' 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 = 'GA' AND d.registrant_city = 'ATLANTA' 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.
N477SBCameron Balloons TR-70 · S/N 11015N477XBUltramagic M-56C · S/N 56/33N92933Cessna 172M · S/N 17261649N91033Cessna 207 · S/N 20700023N445CABeech B-60 · S/N P-411N8042NAero Commander 680V · S/N 1720/91N80860Globe GC-1B · S/N 263N599LGBeech V35A · S/N D-8920N8507FEagle Balloons C-7 · S/N E887112N8511GCessna 172H · S/N 17255501N995RSPiper PA-32R-301T · S/N 32R-8129036N7748QCessna 310Q · S/N 310Q0248N78EBPiper PA-23-250 · S/N 27-7854116N93PPBeech B36TC · S/N EA-531N52495Cessna 177RG · S/N 177RG1200N9432TCessna 210 · S/N 57232N5541KBellanca 8KCAB · S/N 395-78N5586NRidley Clay K SCORPION TOO · S/N RW6900N10PABeech A60 · S/N P-204N515UFBeech F50 · S/N FH-85N2008XCessna 182H · S/N 18256108N5315JAerostar International S-57A · S/N S57A-3234N9803NAdams Balloon A55 · S/N 168N99060Bell TH-13T · S/N 3512N9930LGrumman American Avn. AA-1B · S/N AA1B-0230N9316SBeech B19 · S/N MB-767N7112NBeech D55 · S/N TE-490N899CBCessna 150M · S/N 15076699N30273Lindstrand Balloons 90A · S/N 5116N8038LCessna 172H · S/N 17256238N777MZAero Commander 680-E · S/N 723-29N57733Piper PA-36-285 · S/N 36-7660051N711BFBeech C-45H · S/N AF-300N6700ACessna 172 · S/N 28800N6742UMooney M20D · S/N 168N6813XCessna 172A · S/N 47713N6862YPiper PA-23-250 · S/N 27-4207N60826Cessna 150J · S/N 15070604N611CWBeech E18S · S/N BA-140N6285GCessna 150K · S/N 15071785N63ELCessna 310L · S/N 310L-0088N136BSBeech A36 · S/N E-1725N282SBBeech C24R · S/N MC-632N11ELDouglas DC3 · S/N 2105N5493UBeech 95-C55 · S/N TE-424N5191WPiper PA-28 · S/N 28-226N4975WBen T. Epps BEN T. EPPS 1930 · S/N B.T.E.-3N126DKKohser Douglas A KR-2 · S/N DKKR001AN49100Cessna 152 · S/N 15283418N4735GCessna 172N · S/N 17273334
Back to Atlanta, GA