Skip to content

Cancelled registrations · 68

Query with SQL

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 = 'CA' AND d.registrant_city = 'OCEANSIDE' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'CA' AND d.registrant_city = 'OCEANSIDE'
  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 = 'CA' AND d.registrant_city = 'OCEANSIDE'
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.

N22BNBatto MIDGET MUSTANG M1 · S/N M1-623Cancelled Aug 23, 2023 · Built 1970 · Oshima Ronald D N2347SCessna 337B · S/N 337-0647Cancelled May 6, 2023 · Sale reported, canceled N138CWUltramagic S-90 · S/N 90/152Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 2016 · Munnelly Evan F N6549XCameron Balloons US A-160 · S/N 6623Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Built 2011 · Munnelly Evan F N3518NMooney M20F · S/N 680081Cancelled May 8, 2020 · Revoked, canceled · Built 1967 · Rogers Ralph N49492Cessna 152 · S/N 15281308Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1978 · Suh Robert L N12673Cessna 172M · S/N 17262165Cancelled Aug 23, 2018 · Revoked, canceled · Built 1973 · Cbm Flight Service Inc N717VSchempp-Hirth DISCUS B · S/N 64Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1985 · Jolly Larry L N564ZBDJI PV331 · S/N PH645442150Cancelled May 30, 2018 · Sale reported, canceled N566PBDJI PV331 · S/N PH645451468 V3.0Cancelled May 30, 2018 · Sale reported, canceled N3735QBeech 35-C33A · S/N CE-132Cancelled Mar 16, 2018 · Revoked, canceled · Built 1966 · Brogdon Kimmy C N5557Schempp-Hirth CIRRUS · S/N 37Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1968 · Jolly Larry L N2481BAirmate HP-11 · S/N 73Cancelled Feb 27, 2018 · Registration pending, canceled · Built 1966 N41017Bowers Fly Baby 1-A · S/N 67-13Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1969 · Stowe James L N989EPHurricane HP · S/N 1529EPDCancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 1996 · Buckner Galen L N5858CBeech C35 · S/N D-2810Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1951 · Jordan Thomas F N4283PAnderson William R AIR COMMAND 582 · S/N 12SBM2390Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Anderson William R N4209LKennedy H F Ken AX 6 · S/N HAB1Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1991 · Chico Timothy G N5211DCessna 172N · S/N 17272452Cancelled Sep 13, 2016 · Sale reported, canceled · Built 1979 N105JFFarthing James W II BEAVER · S/N 105Cancelled Jul 28, 2015 · Second renewal notice · Built 2006 · Farthing James W II N55288Piper PA-28R-200 · S/N 28R-7335211Cancelled Apr 7, 2015 · Exported to Canada · Built 1973 · Mcnall Stephen D N324WGlasflugel H 301 LIBELLE · S/N 34Cancelled Mar 11, 2015 · Exported to Canada · Built 1966 · Knoll William C N86865Bellanca 14-13 · S/N 1227Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1946 · Bird Marc L N3857CCessna 180 · S/N 31005Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1954 · Studer James A N5101VMorrisey 2150 · S/N FP-1Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1958 · Oceanside Airport Company N2763RBell 206B-III · S/N 2743Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1979 · Pacific Rotors Inc N322REFreedom Flight ROTEC RALLY 3A · S/N 25182Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Freedom Flight Inc N2485Blanco Corell Frank SEA HAWK · S/N 138Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1991 · Blanco Corell F N911FMSchmidt Bruce A AIRSHARK II · S/N 16Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1993 · Schmidt Bruce A N64PAMcshane Paul A PHOENIX · S/N 606Cancelled Jul 15, 2013 · Registration expired, pending cancellation · Built 1988 · Mcshane Paul A N214LJMansfield Jerry TBIRD II · S/N 5430639Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Mansfield Jerry D N78THHimmelrick Tim L FALCON XP · S/N 600219Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1986 · Himmelrick Tim L N6282LGrumman American Avn. AA-1B · S/N AA1B-0082Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1972 · Newmann Holger K N56811Piper PA-28-180 · S/N 28-7405032Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1973 · Grant Reid R N4095GBell 47G-5 · S/N 7905Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Built 1968 · Pacific Rotors Inc N2252WBell 47G-5 · S/N 7966Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1969 · Pacific Rotors Inc N2394TPiper PA-28-140 · S/N 28-7225067Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1971 · Mcarthur W Douglas N19639Taylorcraft A · S/N 246Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1937 · Hoskins Tim J N5399UCessna U206G · S/N U20605280Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1979 · Burdick Frank N3429WPiper PA-32-260 · S/N 32-290Cancelled Feb 8, 2013 · Sale reported, canceled · Built 1966 N4673QCessna T210L · S/N 21059573Cancelled Nov 27, 2012 · Sale reported, canceled · Built 1972 N4194GRaven S-60A · S/N S60A-203Cancelled Aug 21, 2012 · Sale reported, canceled · Built 1982 N4671NBoeing N2S-3 · S/N 75-7825Cancelled Apr 15, 2011 · Exported to Canada · Built 1943 · Mehrer Fritz J N32034Piper PA-28-180 · S/N 28-7505018Cancelled Oct 17, 2006 · Triennial form not returned · Built 1974 · Marks Robert L N3AXWalters VARI-EZE · S/N 921Cancelled May 27, 2003 · Second triennial mailing, no response · Built 1979 · Mayfield James P III N77BWWilliams W-2 · S/N 3334442Cancelled May 14, 2003 · Built 1970 · Federmack Charles N90215Bell 206B · S/N 1698Cancelled Mar 29, 1999 · Triennial form not returned · Markov Mike N5PKKraft Philip O KITFOX 3 · S/N 1130Cancelled Feb 3, 1997 · Triennial form not returned · Kraft Philip O N7113UBalloon Works FIREFLY 8-24 · S/N F8114Cancelled Nov 4, 1996 · Triennial form not returned · Sebby Gerald N N7462TCessna 172A · S/N 47062Cancelled Aug 13, 1991 · Exported to Australia · Gaff Paul E

Back to Oceanside, CA