Boerne, TX
Cancelled registrations · 45
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 = 'BOERNE' 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 = 'BOERNE' 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.
N767BGSchempp Hirth Flugzeugbau ARCUS T · S/N 51N734EVCessna 172N · S/N 17268805N221LHHowell SMITH MINIPLANE DSA1 · S/N LH-1N540TBBain Charles SH-3R · S/N 3254N9523PFeller Clay/Six Chuter SKY RYDER · S/N 971570-2N740NBDJI PHANTOM 3 PROFESSION · S/N P77DCJ15010529N740QBDJI PHANTOM 3 PROFESSION · S/N P77DCF19014068N667ATBell 407 · S/N 53189N595JJabiru USA Sport J250-SP · S/N 415N56548Maule M-6-235 · S/N 7444CN590SABeech B90 · S/N LJ-401N2620DDJI PHANTOM 4 · S/N 07DDD2UOA11412N9154SBeech C23 · S/N M-1703N8722JGriffin Dan MX II · S/N 001N2193SFirefly Balloons FIREFLY 8 · S/N F8-2009N97255Stinson 108 · S/N 108-255N65RVHolmes Arthur O RV-6A · S/N 20342N66ETMooney M20K · S/N 25-0394N6657HCessna 172M · S/N 17265528N516MACessna R172E · S/N R172-0174N2082FBalloon Works FIREFLY 7 · S/N 728N101ARPiper PA-23-250 · S/N 27-7554150N6584SCessna TR182 · S/N R18201692N352SSAero Commander 680 · S/N 680-502-172N9EZJones Clayton S VARIEZE · S/N 259N39AJAdams John E RV-6A · S/N 20065N213BTConsolidated Vultee BT-13A · S/N 9856N6461MStinson 108-3 · S/N 108-4461N300HFPiper PA-31-325 · S/N 31-7812008N7396CCessna TU206G · S/N U20603920N826WPCessna 150B · S/N 15059645N159DBCessna T210N · S/N 21064139N18ATSmith AEROSTAR 601P · S/N 61P-0391-132N7183GCessna 172K · S/N 17258883N8089JRans Employee Flying Club S-16 SHEKARI · S/N 0498003N46LGJensen Steve LANCAIR LEGACY FG · S/N LS 217N383BBecker Werner PULSAR · S/N 207N2894DBoeing E75 · S/N 75-5624N73004Cessna 140 · S/N 10209N1401TPiper PA-34-200 · S/N 34-7250309N360DRRosinbaum Daryl A GLASAIR SH 2R · S/N SH557N57DBButemeyer EVANS VP-1 DB-1 · S/N 101N714VRCessna 152 · S/N 15279471N148HErcoupe 415-C · S/N 311N613APiper PA-22 · S/N 22-16
Back to Boerne, TX