OpenAirDocs.org
Hialeah, FL

Cancelled registrations · 261

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

N4403Convair 440 · S/N 486Cancelled Mar 25, 1971 · Exported to Panama · Trademark Leasors IncN4404Convair 440 · S/N 487Cancelled Mar 25, 1971 · Exported to Panama · Trademark Leasors IncN46739Ryan Aeronautical ST3KR · S/N 1011Cancelled Mar 17, 1971 · Raymond A ThaneyN89421Cessna 140 · S/N 8453Cancelled Jan 4, 1971 · Lunsford William H JrN29510Taylorcraft BL-65 · S/N 2353Cancelled Dec 7, 1970 · Built 1940 · Smalley J EN2520BLockheed 49-46 · S/N 2081Cancelled Dec 4, 1970 · Covert Hubert MN3171HEngineering & Research 415-C · S/N 3796Cancelled Nov 24, 1970 · Built 1946 · Cunningham Robert LN81215Fairchild 24R-9 · S/N R-46116Cancelled Oct 26, 1970 · De Larm Edward ON82786Aeronca 7AC · S/N 7AC-1433Cancelled Sep 16, 1970 · Skinner AndrewN93784Engineering & Research 415-C · S/N 1107Cancelled Sep 8, 1970 · W F RadcliffeN35282Piper J5A · S/N 5-600Cancelled Sep 1, 1970 · Whistle L PN86532Lockheed 49-46 · S/N 2069Cancelled Aug 28, 1970 · Exported to Peru · Adorisio Alvaro JuanN5101YPiper PA-23-250 · S/N 27-2126Cancelled Jul 29, 1970 · Exported to Chile · Built 1962 · Aero Corporation Of MiamiN81839Aeronca 7AC · S/N 7AC-462Cancelled Jul 14, 1970 · Cadavid Bernardo Horacio AlarcaN456MBeech D18S · S/N A-255Cancelled Jun 24, 1970 · Exported to Brazil · International Export Import CoN5943XBrantly B-2 · S/N 81Cancelled Jun 22, 1970 · Wright Robert JN5954XBrantly B-2 · S/N 95Cancelled Jun 22, 1970 · Wright Robert JN125VBeech D18S · S/N A307Cancelled Feb 24, 1970 · Exported to Brazil · International Export Import CoN64859Curtiss Wright C-46D · S/N 22340 (44-78517)Cancelled Mar 5, 1969 · Exported to Thailand · Tradewinds Cargo IncN63335Curtiss Wright C-46D · S/N 33549Cancelled Nov 18, 1968 · Tradewinds Cargo IncN52331Curtiss Wright C-46D · S/N 32944Cancelled Oct 10, 1968 · Exported to Thailand · Tradewinds Cargo IncN53921Curtiss Wright C-46D · S/N 32984Cancelled Oct 10, 1968 · Exported to Thailand · Tradewinds Cargo IncN62388Curtiss Wright C-46D · S/N 22340Cancelled Aug 20, 1968 · Tradewinds Cargo IncN62388Curtiss Wright C-46D · S/N 33439Cancelled Aug 20, 1968 · Exported to Thailand · Tradewinds Cargo IncN60576Curtiss Wright C-46D · S/N 33274Cancelled Nov 2, 1967 · Exported to Thailand · Tradewinds Cargo IncorporatedN59346Curtiss Wright C-46D · S/N 33269Cancelled Oct 2, 1967 · Exported to Thailand · Tradewinds Cargo IncorporatedN7468BAmerican Champion 7EC · S/N 7EC-526Cancelled Aug 28, 1967 · Exported to Bolivia · Bacigalupo Vincent EN57369Curtiss Wright C-46D · S/N 33249Cancelled Jun 29, 1967 · Exported to Thailand · Built 1966 · Tradewinds Cargo IncorporatedN48130Helio 500 · S/N 4Cancelled Jun 2, 1967 · Exported to Thailand · Tradewinds Cargo IncN56317Curtiss Wright C-46D · S/N 33118Cancelled Apr 27, 1967 · Exported to Thailand · Built 1967 · Tradewinds Cargo IncorporatedN54773Curtiss Wright C-46D · S/N 33105Cancelled Mar 9, 1967 · Exported to Thailand · Tradewinds Cargo IncN4651SSikorsky HO5-S1 · S/N 52086Cancelled Mar 2, 1967 · Exported to Panama · Built 1964 · Daily John KN51657Curtiss Wright C-46D · S/N 32933Cancelled Oct 26, 1966 · Exported to Thailand · Tradewinds Crago IncN1017MHoward DGA-15P · S/N 568Cancelled Sep 13, 1965 · Hartman H TN71570Luscombe 8A · S/N 2997Cancelled May 20, 1965 · Ayers CharlesN56000Cessna T-50 · S/N 6634Cancelled May 14, 1965 · Hill Charles WN525CStinson 108-3 · S/N 108-3525Cancelled Mar 26, 1965 · George W EvansN9333ZNorth American B-25J · S/N 44-86772ACancelled Dec 7, 1964 · Exported to Argentina · Brown David WN127FDehavilland OTTER U-1A · S/N 55-3305Cancelled Jul 30, 1964 · Exported to Canada · Ferrer AviationN128FDehavilland OTTER U-1A · S/N 55-5321Cancelled Jul 30, 1964 · Exported to Canada · Ferrer FrankN48XBensen B7-M · S/N NL-1BCancelled Feb 20, 1964 · Built 1958 · Noyes Norman And Lane David EN61834Cessna T-50 · S/N 5474Cancelled Aug 9, 1963 · Hill Charles WN4621SDouglas C-54G · S/N AAF-45587Cancelled Dec 6, 1962 · Exported to Brazil · Aero Supply International IncN3049KCulver V · S/N 268Cancelled Mar 5, 1962 · Moxley James KN3757ZPiper PA-18-150 · S/N 18-7519Cancelled Nov 24, 1961 · Exported to Ecuador · Built 1969 · Weigand John LN3758ZPiper PA-18-150 · S/N 18-7520Cancelled Nov 24, 1961 · Exported to Ecuador · Built 1960 · Weigand John LN3754ZPiper PA-18-150 · S/N 18-7516Cancelled Nov 13, 1961 · Exported to Ecuador · Weigand John LN40035Piaggio P.136-L2 · S/N 234Cancelled Nov 1, 1961 · Exported to Peru · Global Aero ServiceN43341Taylorcraft BC12-D · S/N 7000Cancelled May 23, 1961 · Built 1946 · Ahrens Charles LN2822MPiper PA-12 · S/N 12-1407Cancelled Apr 17, 1959 · Exported to Canada · Built 1946 · Hampton Donald E
Back to Hialeah, FL