Skip to content

Cancelled registrations · 379

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 = 'MD' AND d.registrant_city = 'BALTIMORE' 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 = 'MD' AND d.registrant_city = 'BALTIMORE'
  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 = 'MD' AND d.registrant_city = 'BALTIMORE'
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.

N19633Taylorcraft A · S/N 240Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1937 · Clarke William E Jr N6980Wheeler BENSEN B-8M · S/N 1Cancelled Sep 3, 2014 · Revoked, canceled · Built 1973 · Wheeler George W N7GYErcoupe 415-D · S/N 1914Cancelled May 20, 2014 · Built 1973 · Strebeck Andrew E N26RVHughes 369F · S/N 0085FFCancelled Nov 6, 2013 · Registration expired, pending cancellation · Franklin Air Company N22JWExtra Flugzeugbau EA300/200 · S/N 07Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1997 · Goggins Edward W N4304KWestinghouse Airship SENTINEL 1000 · S/N S1000-01Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Westinghouse Airships Inc N31459Joyner Luther Earl STARLITE-JOYNER · S/N 71543-JCancelled Oct 18, 2013 · Registration expired, pending cancellation · Joyner Luther E N99995Ercoupe 415-C · S/N 2618Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1946 · Hall Frank Edward N74799Mooney M20B · S/N 1799Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1961 · Gatch Benton Ray N65659Cessna 172P · S/N 17275805Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1982 N218DDDiehl Donald D JR MINI 500 · S/N 0232Cancelled Aug 20, 2013 · Sale reported, canceled N5279ZPiper PA-22-108 · S/N 22-8974Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1961 N6045FBeech 76 · S/N ME-183Cancelled Aug 19, 2013 · Registration expired, pending cancellation · Built 1979 · Commercial Credit Equipment Corp N5439QCessna 150L · S/N 15073339Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1972 · Reiter Pamela Rae N6116KRepublic RC-3 · S/N 299Cancelled Aug 7, 2013 · Revoked, canceled · Built 1947 · Hewitt Joseph K N2333ZBeech 23 · S/N M-49Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1962 N1173KLuscombe 8A · S/N 3900Cancelled Jul 16, 2013 · Revoked, canceled · Built 1946 · Berger Arthur J N9704KStinson 108-2 · S/N 108-2704Cancelled Jul 16, 2013 · Registration expired, pending cancellation · Built 1947 · Wallace Robert L N425BBeech A35 · S/N D-1646Cancelled Jul 15, 2013 · Sale reported, canceled · Built 1948 N43425Taylorcraft BC12-D · S/N 7084Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1946 · Walker James C N9195HStinson VULTEE V-77 · S/N 77-383Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1944 · Dean Arthur E Jr N93924Ercoupe 415-C · S/N 1247Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1946 · Wallace Robert L N8622CPiper PA-22-135 · S/N 22-1303Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1953 · Schraml Albert J N74175Douglas DC-7C · S/N 44883Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1956 · Burch Francis B N64816Bell H13G · S/N 1255Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1959 · Dover International Machine Ltd N6481ACessna 182 · S/N 33281Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1956 · Dorsey John F N63444Cessna 150M · S/N 15077318Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1975 · Mcgowan James F N6186GCessna 150K · S/N 15071686Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1969 · Skarbek Roman A N3165TCessna 177 · S/N 17700465Cancelled Apr 16, 2013 · Registration expired, pending cancellation · Built 1967 · Mcgowan James F N64REPound Robert J RALLY 3A · S/N 64775Cancelled Apr 1, 2013 · Sale reported, canceled · Built 1982 N97251Stinson 108 · S/N 108-251Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1946 N9049DPiper PA-22-160 · S/N 22-6188Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1958 N90592Schmeisser B-8MW · S/N GS1Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1973 N6548UMooney M20C · S/N 2331Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1962 N44325Piper PA-28-180 · S/N 28-7405234Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1974 · Wahlhaupter John N Jr N432MDCessna 210E · S/N 21058706Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Built 1965 · Faison William R N2380GCessna 182B · S/N 51680Cancelled Sep 6, 2012 · Registration expired, pending cancellation · Built 1958 · Nelson Robert H N69361Cessna T-50 · S/N 3638Cancelled Sep 6, 2012 · Revoked, canceled · Built 1942 · French H W Avia Sch Inc N60240Cessna T-50 · S/N 2213Cancelled Aug 30, 2012 · Revoked, canceled · Built 1941 · Patterson William M N61364Cessna T-50 · S/N 6566Cancelled Aug 30, 2012 · Revoked, canceled · Built 1943 · Atlantic Arcft Distributors Inc N453VEurocopter EC120B · S/N 1205Cancelled Aug 21, 2012 · Exported to Norway · Built 2001 · Mayor And City Council Of Baltimore N454VEurocopter EC120B · S/N 1219Cancelled Aug 21, 2012 · Exported to Norway · Built 2001 · Mayor And City Council Of Baltimore N31DTCentrair 101A · S/N 101A0127Cancelled Aug 8, 2012 · Registration pending, canceled · Built 1984 N4796ZPiper PA-22-108 · S/N 22-8362Cancelled Aug 7, 2012 · Revoked, canceled · Built 1961 · United Flying Service Inc N451VEurocopter EC120B · S/N 1124Cancelled Jul 23, 2012 · Exported to Norway · Built 2000 · Mayor And City Council Of Baltimore N452VEurocopter EC120B · S/N 1199Cancelled Jul 23, 2012 · Exported to Norway · Built 2001 · Mayor And City Council Of Baltimore N118MDouglas DC3C · S/N 9026Cancelled Jun 4, 2012 · Sale reported, canceled · Built 1943 N40757Piper J3C-65 · S/N 7481Cancelled Jun 4, 2012 · Revoked, canceled · Built 1941 · Skylarks Flying Club Inc N210DUAlisport SILENT 2 · S/N 2010Cancelled May 24, 2012 · Registration expired, pending cancellation · Built 2004 · Silent Alisport LLC N5849MCessna 310P · S/N 310P0149Cancelled May 18, 2012 · Revoked, pending cancellation · Built 1969 · Haven Chemical Corp

Back to Baltimore, MD