None, OK
Cancelled registrations · 414
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 = 'OK' AND d.registrant_city = 'NONE' 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 = 'OK' AND d.registrant_city = 'NONE' 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.
N75REGray Tom RALLY 3A · S/N 64773N8798SCessna 150F · S/N 15062098N7642HPiper PA-12 · S/N 12-517N823ATDouglas DC-9-32 · S/N 47529N1084CChaconas Constantine Peter DRUINE TURBULENT · S/N 1N741PPiper PA-31T · S/N 31T-7720025N4506LAir Tractor AT-402A · S/N 402A-0749N6230BAero Commander 720 · S/N 720-820-12N397EAAlvarado Emilio A ALVA GYRO 1 · S/N 001N22UPPiper PA-42 · S/N 42-8001079N1370CPiper PA-18A · S/N 18-2621N747PBell 206B · S/N 2867N5164RAerostar International S-77A · S/N S77A-3028N7065CRobinson Helicopter R66 · S/N 0329N134LARobinson Helicopter R44 II · S/N 11931N43RSSchleicher ASW-27 · S/N 27120N66NHBell UH-1H · S/N 6601141N600DNRockwell International S-2R · S/N 2109RN320DWForbes COBRA · S/N F-3N202ABCorda Stephen G-202 · S/N G-20229N9292EAeronca 11AC · S/N 11AC-930N105MXEipper MX SUPER · S/N 1028N4031TAdams Balloon A55S · S/N 123N702GBAero SP Z O O AT-4 LSA · S/N AT4-002N6767SCessna 150H · S/N 15067567N1907KLuscombe 8F · S/N 4634N2598APiper PA-38-112 · S/N 38-78A0770N2365KSilvaire LUSCOMBE 8A · S/N 5092N27VXFairchild 24 G · S/N 2929N707DSTop Dog 503 · S/N 001N74EWReco 162F · S/N 6989N202PRRobinson Helicopter R22 BETA · S/N 1031N22576Pitts Special S-1C · S/N GWC-1N582RJStontz John AVID FLYER C · S/N 931N65ESBell 206B · S/N 1642N8409CPiper PA-28-151 · S/N 28-7615104N26072Piper J3C-65 · S/N 4033N194DEEvans William D QUICKSILVER GT-500 · S/N 152N7310DPiper PA-22-150 · S/N 22-5098N9082NAero Commander 500 S · S/N 3068N126RRAntonov AN-2R · S/N 1G12601N4364DHudson John D REVOLUTION MINI 500 · S/N 0318N57ACBeech B200 · S/N B-857N980AARockwell International 695 · S/N 95001N95218Taylorcraft BC12-D · S/N 9618N216EKKorzep ED BUCCANEER SX 503 · S/N B1A-416-503N851JABritten-Norman BN2A-26 ISLANDER · S/N 913N72RHSikorsky UH-34J · S/N 143954N3023JSmith S P/Smith C A KITFOX-CLASIC IV · S/N C9502-0103N7762VAero Commander CALLAIR A-9B · S/N 1519
Back to None, OK