Skip to content

Cancelled registrations · 45

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 = 'EDWARDS' 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 = 'EDWARDS'
  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 = 'EDWARDS'
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.

N885NAMcdonnell Douglas F-15D · S/N 78-0565Cancelled Oct 27, 2025 · Nasa Neil A Armstrong Flight Research Center N509NUBob Violett Models KINGCAT · S/N KC09100115Cancelled Jan 11, 2025 · Sale reported, canceled N747NABoeing 747SP-21 · S/N 21441Cancelled Jul 18, 2024 · Built 1977 · Nasa Neil A Armstrong Flight Research Center N817NADouglas DC-8-72 · S/N 46082Cancelled Jul 18, 2024 · Built 1969 · Nasa Neil A Armstrong Flight Research Center N401SCCirrus Design SR22 · S/N 0951Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Built 2004 · Berra Lee N863NANorthrop T-38A · S/N 68-8116Cancelled Mar 7, 2018 · Registration expired, pending cancellation · National Aeronautics And Space Administration N864NANorthrop T-38B · S/N 68-8113Cancelled Mar 7, 2018 · Registration expired, pending cancellation · National Aeronautics And Space Administration N7997LBeech A23-19 · S/N MB-165Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1966 · Nielsen Michael B N80354Buckeye DREAM MACHINE · S/N 4178Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 1998 · Accurso Anthony Paul N36629Balloon Works FIREFLY 7 · S/N F7-058Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1983 · Rosepink Ronald K DBA N9689CPiper PA-28-181 · S/N 28-7890437Cancelled Sep 11, 2013 · Registration expired, pending cancellation · Built 1978 · Fiedler Harald P N268BALet L-23 SUPER BLANIK · S/N 938028Cancelled Sep 10, 2013 · Registration expired, pending cancellation · Built 1993 · United States Air Force N502NASchweizer SGS 1-36 · S/N 1Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1979 N526ZGMoravan ZLIN-Z326 · S/N 869Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1967 · Osika Peter M N85MRDi Giacomo Michael LONG-EZ · S/N 1704Cancelled Apr 24, 2013 · Registration expired, pending cancellation · Built 1986 · Di Giacomo Michael N5128KGreat Plains Acft Supply SONERAI II LS · S/N 061392261Cancelled Nov 7, 2012 · Sale reported, canceled N164LACessna 150G · S/N 15066379Cancelled Aug 9, 2012 · Registration expired, pending cancellation · Built 1967 · Leavitt Harold R N840NAMcdonnell Douglas FA-18A · S/N 160780Cancelled Dec 8, 2011 · First renewal notice · National Aeronautics And Space Administration N837NAMcdonnell Douglas F-15B · S/N 71-0290Cancelled Nov 17, 2011 · First renewal notice · National Aeronautics And Space Administration N845NAMcdonnell Douglas FA-18B · S/N 160781Cancelled Nov 17, 2011 · First renewal notice · National Aeronautics And Space Administration N847NAMcdonnell Douglas FA-18A · S/N 161520Cancelled Nov 17, 2011 · First renewal notice · National Aeronautics And Space Administration N851NAMcdonnell Douglas FA-18A · S/N 161705Cancelled Nov 17, 2011 · First renewal notice · National Aeronautics And Space Administration N22647Taylorcraft BF · S/N 1294Cancelled May 23, 2011 · Revoked, canceled · Built 1939 · Hasbrook William B N710NAConvair 30 · S/N 30-29Cancelled Jun 29, 2009 · Triennial form not returned · Built 1962 · National Aeronautics And Space Administration N825NALockheed TF-104G · S/N 583D-5939Cancelled Oct 6, 2003 · Triennial form not returned · Nasa Ames Research Center N826NALockheed F-104G · S/N 683-8213Cancelled Oct 6, 2003 · Triennial form not returned · Nasa Ames Research Center N808NAPiper PA-30 · S/N 30-1498Cancelled Feb 5, 2002 · Triennial form not returned · Built 1967 · National Aeronautics And Space Admin N805NALearjet 24A · S/N 102Cancelled Sep 18, 2001 · Triennial form not returned · National Aeronautics And Space Adm N5153FCessna 172F · S/N 17253000Cancelled Jun 14, 2001 · Second triennial mailing, no response · U S Air Force Owner N824NALockheed TF-104G · S/N 583D5735Cancelled Sep 24, 1996 · Triennial form not returned · Nasa Ames Research Center N816NAConvair NF-106B · S/N 572516Cancelled Apr 22, 1992 · Triennial form not returned · Nasa Dryden Flight Research Center N5567BRaven Industries RALLY RX7 · S/N RX7-189Cancelled Jul 19, 1991 · Sale reported · Built 1979 N827NADouglas C-47D · S/N 43-49526Cancelled Jan 17, 1985 · Administratively canceled · Nasa Dryden Flight Research Center N833NABoeing 720-027 · S/N 18066Cancelled Jan 17, 1985 · Administratively canceled · Nasa Dryden Flt Research Fac N818NALockheed F-104A · S/N 1007Cancelled Oct 15, 1981 · National Aeronautics & Space Administration N803NANorthrop M2-F3 · S/N NLB-101Cancelled Dec 31, 1980 · National Aeronautics And Space Admin N804NANorthrop HL-10 · S/N NLB-102Cancelled Nov 12, 1980 · National Aeronautics & Space Admin N810NALing-Temco-Vought F-8A · S/N 141353Cancelled Nov 12, 1980 · National Aeronautics And Space Administration N820NALockheed F-104A · S/N 1078Cancelled Nov 12, 1980 · Nasa N816NALing-Temco-Vought F-8A · S/N 145385Cancelled May 6, 1975 · National Aeronautics And Space Administration N45208Let BLANIK L-13 · S/N 173205Cancelled Jul 26, 1972 · Latimer Loring K N802NADouglas F5D-1 · S/N 142350Cancelled Dec 7, 1971 · National Aeronautics And Space Administration N825NAGeneral Dynamics F-111A · S/N 6Cancelled Apr 8, 1970 · National Aeronautics And Space Administration N826NAGeneral Dynamics F-111A · S/N 12Cancelled Apr 8, 1970 · National Aeronautics And Space Administration N86652Unknown UNKNOWN · S/N 102Cancellation date not recorded · Nasa Flight Research Center

Back to Edwards, CA