Skip to content

Cancelled registrations · 131

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

N889CLBoeing 737-8LZ · S/N 42510Cancelled Sep 6, 2024 · Exported to San Marino · Built 2013 · Pasaca Capital Inc N89084Cessna 152 · S/N 15282623Cancelled Mar 22, 2023 · Third renewal notice · Built 1978 · Aero Association Of Caltech Inc N6855MStinson 108-3 · S/N 108-4855Cancelled Jan 14, 2023 · Sale reported, canceled · Built 1949 N96LFDJI INSPIRE 2 RAW · S/N 09YDE7ML040384Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Los Feliz Airlines LLC N67717Beech D17S · S/N 4841Cancelled Jul 19, 2021 · Revoked, canceled · Built 1943 · Nienstedt D A N207PPBell OH-58A · S/N 69-16336Cancelled Apr 21, 2020 · Pasadena Police Deptartment N463FMDroidworx SKYJIB ADHL · S/N HO1DWSJX8Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Farnams Motion Picture Service Inc DBA N686DNSikorsky UH-60A · S/N 80-23509Cancelled Jan 29, 2020 · Third renewal notice · Rogerson Kratos N2869MPiper PA-12 · S/N 12-1298Cancelled Nov 22, 2019 · Revoked, canceled · Built 1946 · Mcgehee James D N9028EAeronca 11BC · S/N 11AC-656Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Built 1946 · Powers Leanne N85926Aeronca 11AC · S/N 11AC351Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Smith Harry L N522BLLsa America ALLEGRO · S/N 14-009Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 2014 · Jitco Group Ltd N522CHLsa America ALLEGRO · S/N 14-010Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 2014 · Jitco Group Limited N6115ZHY Tek HURRICANE · S/N 001Cancelled Feb 15, 2018 · Registration expired, pending cancellation · Built 2001 · Davis Brent R N741SBMooney M20M · S/N 27-0285Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 2000 · Law Offices Of Norman Boxley Inc N111WTTaylorcraft BC12-D · S/N 8040Cancelled Oct 28, 2017 · Revoked, canceled · Built 1946 · Davison Earl L N62959Piper PA-31-350 · S/N 31-7752008Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Built 1976 · Uas Transervices Inc N5078WPiper PA-28 · S/N 28-87Cancelled Jun 20, 2017 · Registration expired, pending cancellation · Built 1961 · Atc Corporation N909WAAerospatiale AS350B · S/N 1227Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Built 1980 · Fleet Unlimited Inc N7102XCessna 150A · S/N 15059202Cancelled Feb 4, 2017 · Revoked, canceled · Built 1961 · Jackson David C N9960WPiper PA-28-140 · S/N 28-23507Cancelled Jan 19, 2017 · Third renewal notice · Built 1967 · Atol Dane N1233XMooney M20E · S/N 107Cancelled Oct 13, 2015 · Built 1963 · Keep It Moving Edutainment Inc N469MDBeech 58P · S/N TJ-331Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1981 · H & W Management Services Inc N2651NCessna 120 · S/N 12909Cancelled May 8, 2015 · Registration expired, pending cancellation · Built 1947 · Stokes Michael J N2580HSchweizer SGS 1-26E · S/N 670Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1977 · Fleischman Don U N9541CPiper PA-28R-201T · S/N 28R-7803265Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1978 · Wright James O N55232Bensen B-8M · S/N 1Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1982 · Sanders Mark S N911FABell OH-58 · S/N 70-15152Cancelled Nov 15, 2013 · First renewal notice · Pasadena Police Department N96BMBell OH-58A · S/N 72-21364Cancelled Nov 15, 2013 · Pasadena Police Department N68152Fairchild M-62A · S/N T424249Cancelled Oct 23, 2013 · Revoked, canceled · Built 1942 · Stevens James L N921PPitts Special S-1S · S/N 26PCancelled Sep 11, 2013 · Registration expired, pending cancellation · Built 1970 · Parham Otis B Jr N65111Baker SCORPION TOO · S/N 0559Cancelled Aug 7, 2013 · Revoked, canceled · Built 1975 · Baker George B N1BAEwing Jim GLASAIR · S/N 215Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1986 · Ziomkowski Chris N3295TCessna 177 · S/N 17700595Cancelled Jun 24, 2013 · Third renewal notice · Built 1967 · Samuelian Philip N3935TPiper PA-28R-180 · S/N 28R-30276Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1967 · Franz Charles M N8807ABeech B35 · S/N D-2229Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1950 · Mills Ronald N7105CBalloon Works FIREFLY 7 · S/N F7-373Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1987 · Douglass James M N7129Beech 3NM · S/N CA-217Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1955 · Paralift Inc N6881RCessna T210G · S/N T210-0281Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1967 · Bliss Gail E N37651Mills William J MITCHELL U-2 SUPER · S/N 235Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Mills William J N5548Douglas A-4B · S/N A11-32Cancelled Apr 22, 2013 · Registration expired, pending cancellation · George T Baker Aviation School N55672Raven Industries RALLY RX7 · S/N RX7-199Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1980 · Jones Frank B N82030Piper PA-22-150 · S/N 22-3637Cancelled Mar 18, 2013 · Sale reported, pending cancellation N7777TAero Commander 560-E · S/N 779Cancelled Feb 26, 2013 · Sale reported, canceled · Built 1959 N2946HErcoupe 415-C · S/N 3571Cancelled Feb 25, 2013 · Registration expired, pending cancellation · Built 1946 · Mullikin Perry A N56852Consolidated Vultee BT-13A · S/N 7241Cancelled Feb 21, 2013 · Revoked, canceled · Built 1942 · Woodhouse Lee N45CCessna T337G · S/N P3370113Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1973 · Avery R Stanton N8680ABeech A35 · S/N D-2090Cancelled Nov 14, 2012 · Sale reported, pending cancellation · Built 1949 N1802XCessna 182H · S/N 18255902Cancelled Aug 1, 2012 · Sale reported, canceled · Built 1964 N27579Piper PA-31-350 · S/N 31-7852063Cancelled Mar 23, 2012 · Built 1978 · Uas Transervices Inc

Back to Pasadena, CA