OpenAirDocs.org
Largo, FL

Cancelled registrations · 87

Query with SQL
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 = 'FL' AND d.registrant_city = 'LARGO'
  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.

N963AMArcher Edward S DOLPHIN 2 · S/N 001Cancelled Dec 10, 2021 · Registration expired, pending cancellation · Built 2006 · Archer Edward SN711LKBeech D18S · S/N A424Cancelled Apr 7, 2021 · Revoked, canceled · Built 1957 · Socha Richard AN12AJSchleicher ASW-20C · S/N 20703Cancelled May 30, 2019 · Exported to Argentina · Built 1983 · Diaz Enrique JN93294Cessna 152 · S/N 15285461Cancelled Mar 16, 2019 · Registration expired, pending cancellation · Built 1981 · Rothermel James JN2024YCessna 172S · S/N 172S9970Cancelled Jul 20, 2018 · Exported to Philippines · Built 2005 · Florida Aircraft Marketing LLCN5253QCessna 172S · S/N 172S9168Cancelled Jul 20, 2018 · Exported to Philippines · Built 2002 · Florida Aircraft Marketing LLCN9069CCessna R182 · S/N R18200385Cancelled Jun 1, 2018 · Sale reported, canceled · Built 1978N1725VCessna 172M · S/N 17263726Cancelled Feb 26, 2018 · Exported to Panama · Built 1974 · Florida Aircraft Marketing LLCN69872Max Air Drifter MU 582 · S/N 480Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1997 · Bailey Randy EN2183FYakovlev YAK 52 · S/N 899311Cancelled Nov 8, 2017 · Expired dealer · Built 1989 · White Gene WN2418TNavion NAVION G · S/N NAV-4-2418Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1962 · Regal David NN932MJMcdonnell Douglas DC-9-31 · S/N 48156Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1982 · Southeast Airlines IncN933JKDouglas DC-9-31 · S/N 48159Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1982 · Southeast Airlines IncN103RGAmerican AA-1 · S/N AA1-0151Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1969 · Meyers Stephen LN701BCPiper PA-28-140 · S/N 28-7325390Cancelled May 15, 2017 · Registration expired, pending cancellation · Built 1973 · Clough BradfordN28007Bellanca 17-30A · S/N 78-30885Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Built 1978 · Eagan Jeffery KN601PKFerguson Peter K 601 HDS · S/N 001Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Ferguson Peter KN97312Stinson 108 · S/N 108-312Cancelled Feb 17, 2017 · Registration expired, pending cancellation · Built 1946 · Gooch Raymond WN1172XCessna 172S · S/N 172S10378Cancelled Aug 15, 2016 · Exported to Spain · Built 2006 · Florida Aircraft Marketing LLCN559FACessna 172S · S/N 172S9559Cancelled May 13, 2016 · Exported to Canada · Built 2003 · Florida Aircraft Marketing LLCN697SACessna 172S · S/N 172S8593Cancelled May 5, 2016 · Exported to Canada · Built 2000 · Florida Aircraft Marketing LLCN155TMDarrow Stephen Allen BUCCANEER 2B2 · S/N 091953Cancelled May 18, 2015 · Registration expired, pending cancellation · Mangan Thomas JN605BWWest Bradford C MAXAIR DRIFTER · S/N BW001Cancelled Apr 27, 2015 · Registration expired, pending cancellation · West Bradford CN557ERCessna 172S · S/N 172S10580Cancelled Dec 31, 2014 · Exported to Indonesia · Built 2007 · Florida Aircraft Marketing LLCN556DFBethard David J DRAGONFLY · S/N 556Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1985 · Preiato James VN5310MCessna 152 · S/N 15284525Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Moll Milton MN7679Schweizer SGS 1-34 · S/N 59Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1971 · Tampa Bay Soaring Society IncN5595DBeech H35 · S/N D-5151Cancelled Oct 28, 2014 · Registration expired, pending cancellation · Built 1957 · Noell Robert E JrN44281Taylorcraft BC12-D1 · S/N 10081Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1946 · Hines Charles M JrN4553VBeech 35 · S/N D-1381Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1948 · C And Airfoto IncN2537AColumbia Aircraft Mfg LC42-550FG · S/N 42504Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 2006 · Camuzzi Freddy AN19490Cessna 150L · S/N 15074446Cancelled Feb 24, 2014 · Exported to Dominican Republic · Built 1973 · Florida Aircraft Marketing LLCN35331Cessna 172R · S/N 17281037Cancelled Jan 6, 2014 · Exported to Mexico · Built 2001 · Florida Aircraft Marketing LLCN721GCCessna 172S · S/N 172S10721Cancelled Oct 29, 2013 · Exported to Indonesia · Built 2008 · Florida Aircraft Marketing LLCN44294Piper PA-28R-200 · S/N 28R-7435305Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1974 · Calden LouisN747AAStencel Fred B FALCON-XP · S/N 600145Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1986 · Hall Leland BN5448Bell UH-1B · S/N 63-12905Cancelled Aug 6, 2013 · Sale reported, canceledN3561LRaven Industries RALLY RX7 · S/N RX7-3180Cancelled Jul 16, 2013 · Registration expired, pending cancellation · Built 1988 · Southwest Hospitality CorporationN7990TCessna 175A · S/N 56690Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Built 1960 · Ford Michael AN4005RAdams Balloon A55 · S/N 117Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1983 · Norquest Lawrence AN812EZWarren Roger A LONG-EZ · S/N 195Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1982 · Warren Roger AN8614ESchleicher KA 6 CR · S/N 6296Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1965 · Morelli Joseph AnthonyN4123NRans S-12 AIRAILE · S/N 0992290Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1994 · Harding RobertN2124VCessna 172S · S/N 172S9423Cancelled Apr 9, 2013 · Exported to Canada · Built 2003 · Florida Aircraft Marketing LLCN11591Cessna 172S · S/N 172S10359Cancelled Mar 5, 2013 · Exported to New Zealand · Built 2006 · Florida Aircraft Marketing LLCN62981Cessna 172S · S/N 172S10688Cancelled Jan 16, 2013 · Exported to Indonesia · Built 2008 · Florida Aircraft Marketing LLCN664HACessna 172S · S/N 172S10664Cancelled Jan 16, 2013 · Exported to Indonesia · Built 2008 · Florida Aircraft Marketing LLCN65536Cessna 172S · S/N 172S9723Cancelled Jan 9, 2013 · Exported to Canada · Built 2004 · Florida Aircraft Marketing LLCN66045Cessna 172S · S/N 172S9772Cancelled Jan 4, 2013 · Exported to Canada · Florida Aircraft Marketing LLCN4668JPiper PA-28R-180 · S/N 28R-30567Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1968 · Ciampa Louis
Back to Largo, FL