Skip to content

Cancelled registrations · 246

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

N26VPVans RV-12 · S/N 121011Cancelled Apr 5, 2025 · Registration pending, canceled · Built 2018 N116CJFabian C James EXEC 162F · S/N 6372Cancelled May 3, 2024 · Fabian C J N3105FCessna 182J · S/N 18257205Cancelled Jan 23, 2024 · Revoked, canceled · Built 1966 · Villa Building Corporation N26084Kverno FLY BABY 1A · S/N N-75-8Cancelled Apr 18, 2023 · Sale reported, canceled N274DRDavid Reser CX4 · S/N 122Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 2017 · Reser David A N64460Cessna 172M · S/N 17265247Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Hess Garrett J N933SWCessna 402 · S/N 402-0106Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Hancock Christopher D N7046BPiper PA-22-150 · S/N 22-4300Cancelled Jan 31, 2020 · Revoked, canceled · Built 1956 · J And H Air Svc N887GBeech 65-88 · S/N LP-31Cancelled Sep 6, 2019 · Revoked, canceled · Built 1966 · Magnum Enterprises Inc N7679CNorth American AT-6G · S/N 49-3310Cancelled Feb 4, 2019 · Registration expired, pending cancellation · Built 1949 · Fields Richard S N1984CCessna 170B · S/N 26129Cancelled Jan 22, 2019 · Revoked, canceled · Built 1953 · Ful Air Service N97303Stinson 108 · S/N 108303Cancelled Nov 17, 2018 · Revoked, canceled · Built 1946 · Fullerton Flying Club Inc N9112VMooney M20C · S/N 690016Cancelled Oct 12, 2018 · Revoked, canceled · Built 1969 · American Aircraft Leasing Inc N6632BCessna 310B · S/N 35732Cancelled May 18, 2018 · Revoked, canceled · Built 1958 · Ful Air Service N6018PPiper PA-24-250 · S/N 24-1113Cancelled Nov 21, 2017 · Revoked, canceled · Built 1959 · J & H Air Service N4722JCessna 172N · S/N 17273668Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1979 · Caley Jeffrey M N125TWBeech 95-B55 (T42A) · S/N TC-1617Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1973 · Goldman Howard S N7267LAmerican AA-1A · S/N AA1A-0467Cancelled May 21, 2015 · Sale reported, canceled N6300CStreak 225 · S/N 100Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1954 · Pregler Arvin L N80WLLoewen Wallace G VARIEZE · S/N 1412Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1981 · Trikha Rohit N354TJCessna 340A · S/N 340A0042Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1976 · Bybyk Michael John N6763ACessna 172 · S/N 28863Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1956 · Gentry Robert N37073Luscombe 8D · S/N 1734Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1941 · Davis Duane D N3756HMooney M20J · S/N 24-0928Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1979 · Rucker David L N2971Cary VOLKSPLANE VE-1 · S/N 1Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1971 · Hansen Tracy Craig N28ASLet BLANIK L-13 · S/N 027059Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1978 · Skyhaven Inc N6765GCessna 150L · S/N 15072265Cancelled Oct 23, 2013 · Revoked, canceled · Built 1970 · Grodahl John N7176RPiper PA-28-140 · S/N 28-21887Cancelled Aug 16, 2013 · Sale reported, canceled · Built 1966 N24855Cessna 152 · S/N 15280413Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1977 · Aerobanc Of America Inc N9583FHughes 269C · S/N 740330Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1974 · Aeroflite Inc N800WLOsborne L/Carson W FALCON XP · S/N 600228Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Osborne Louie G N6800GCessna 150L · S/N 15072300Cancelled Jul 16, 2013 · Revoked, pending cancellation · Built 1970 · Grodahl John N26258Stinson 10 · S/N 7743Cancelled Jul 15, 2013 · Sale reported, canceled · Built 1940 N16330Piper PA-28-235 · S/N 28-7310088Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1973 N637PSJohnson Leonard G COZY MK-IV · S/N 287Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 2002 · Johnson Leonard G N843PSPiper PA-24-260 · S/N 24-4687Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1967 · Grodahl John DBA N8462PPiper PA-24-400 · S/N 26-37Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1964 · Stewart James L N8165MCessna 310I · S/N 310I0165Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1964 · Helmandollar Boyd V N72096Luscombe 8A · S/N 3523Cancelled May 6, 2013 · Registration expired, pending cancellation · Built 1946 · Davis Duane D N6FMBrowns STOLP STARDUSTER · S/N 444Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1976 · Browns Frederick S N5870FCessna 210G · S/N 21058870Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1967 · Davis Duane D N2053GBeech B-60 · S/N P-489Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1978 · Modern Aero Of California Inc N636RCessna 310D · S/N 39188Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1960 N24807Cessna 152 · S/N 15280390Cancelled Feb 11, 2013 · Registration expired, pending cancellation · Built 1977 · Air South Inc DBA N2512YPiper PA-32R-301 · S/N 32R-8529020Cancelled Feb 11, 2013 · Registration expired, pending cancellation · Built 1985 · Mathews Rick N3676DCessna 310 · S/N 35376Cancelled Nov 8, 2012 · Registration expired, pending cancellation · Built 1956 · Wheatley Jeff R N180EECessna 180 · S/N 31546Cancelled Oct 15, 2012 · Registration expired, pending cancellation · Built 1955 · Peterson Stephan G N3517WPiper PA-31-350 · S/N 31-7952096Cancelled Oct 4, 2012 · Registration expired, pending cancellation · Built 1979 · Dimino Charles F N3268RCessna 411A · S/N 411-0268Cancelled Oct 2, 2012 · Registration expired, pending cancellation · Built 1967 · Crocker National Bank N33758Aeronca 65-CA · S/N C-13271Cancelled Sep 12, 2012 · Sale reported, canceled · Built 1941

Back to Fullerton, CA