OpenAirDocs.org
Harvey, LA

Cancelled registrations · 35

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 = 'LA' AND d.registrant_city = 'HARVEY'
  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.

N95538Polaris 2001 FIB · S/N E 3503J10Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Boatright Michael EN42BBPiper PA-23-250 · S/N 27-3847Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Built 1968 · New Orleans Aviation IncN9786GCessna 180J · S/N 18052286Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1972 · Harvey Canal Seaplane Service IncN734QWCessna U206G · S/N U20604862Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1979 · Signal Air IncN165RBBryan Robert W AVID FLYER · S/N 165Cancelled Apr 2, 2013 · Sale reported, canceledN648LCFortman Louis C ULTRASPORT 496 · S/N 2012Cancelled Apr 5, 2007 · Triennial form not returned · Built 1997 · Keller Jacen PN79430Cessna 172K · S/N 17258079Cancelled Feb 14, 2007 · Triennial form not returned · Built 1969 · Celway LLCN3518LCessna 150F · S/N 15062318Cancelled May 24, 2006 · Triennial form not returned · Built 1965 · Case Ulysses Neal IIIN555RBPiper PA-28R-201T · S/N 28R-7803199Cancelled Dec 2, 2005 · Triennial form not returned · Built 1978 · D P Aeronautics IncN22NFFulco Neal A QUICKIE · S/N 1Cancelled Aug 10, 2000 · Triennial form not returned · Fulco Neal AN2818LCessna 172H · S/N 17256018Cancelled Feb 10, 2000 · Triennial form not returned · D P Aeronautics IncN7053ZPiper PA-25-235 · S/N 252822Cancelled Oct 29, 1991 · Triennial form not returned · Warner Lester AN111DMCessna 337A · S/N 3370408Cancelled Jul 20, 1983 · Administratively canceled · Dixie Buick IncN52072Cessna 180H · S/N 18052480Cancelled Aug 20, 1981 · Harvey Canal Seaplane Service IncN2594KCessna 180K · S/N 18053008Cancelled Apr 8, 1981 · Exported to Canada · Built 1978 · New Orleans Aviation IncN5074RCessna 185 · S/N 18502998Cancelled Apr 8, 1981 · Exported to Canada · New Orleans Aviation IncN42322Cessna 180J · S/N 18052341Cancelled Jan 12, 1981 · Built 1973 · Harvey Canal Seaplane Service IncN50600Cessna 150J · S/N 15069425Cancelled May 31, 1977 · Air Travel IncN2126ZCessna 180F · S/N 18051226Cancelled Aug 21, 1973 · Exported to Canada · Harvey Air Taxi IncN2116ZCessna 180F · S/N 180-51216Cancelled Jun 1, 1973 · Exported to Canada · Marshland Aviation IncN7736JPiper PA-32-260 · S/N 32-1139Cancelled Jul 7, 1972 · Built 1969 · Chandler Charles HN41982Grumman G-44A · S/N 1413Cancelled Aug 6, 1968 · Built 1945 · J Ray Mcdermott & Co IncN111WGrumman G-44 · S/N 1361Cancelled May 8, 1968 · Circle IncorporatedN2502DCessna 170B · S/N 20654Cancelled Aug 3, 1967 · Exported to Canada · Southern SeaplaneN37187Grumman G-44 · S/N 1237Cancelled May 4, 1966 · Built 1941 · J Ray Mcdermott & Co IncN98018Piper J3C-65 · S/N 18160Cancelled May 25, 1965 · Hubert J Chaisson SrN4938ACessna 180 · S/N 32335Cancelled Aug 4, 1958 · J Ray Me Dermott & Co IncN2867ACessna 180 · S/N 30067Cancelled Dec 12, 1955 · J Ray Mcdermott & Co IncN5426CCessna 170A · S/N 19559Cancelled Oct 4, 1955 · Young & Elkins Rental ToolsN9642ACessna 140A · S/N 15363Cancelled Dec 17, 1952 · J Ray Mcdermott & Co IncN3136KCulver V · S/N V-355Cancelled Aug 25, 1952 · Utley Merrill HN9706ACessna 170A · S/N 19167Cancelled Dec 19, 1951 · J Ray Mcdermott & Co IncN99733Ercoupe 415-C · S/N 2356Cancelled Dec 4, 1951 · Ridge GeneN94757Ercoupe G · S/N 5028Cancelled Oct 24, 1951 · J Ray Mcdermott & Co. Inc.N36030Taylorcraft BCS12-65 · S/N 2995Cancelled Aug 1, 1951 · Built 1941 · Folse Thompson L
Back to Harvey, LA