Skip to content

Cancelled registrations · 204

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 = 'FL' AND d.registrant_city = 'HOMESTEAD' 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 = 'FL' AND d.registrant_city = 'HOMESTEAD'
  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 = 'FL' AND d.registrant_city = 'HOMESTEAD'
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.

N2576XCessna P206 · S/N P206-0076Cancelled Mar 8, 1974 · Exported to Venezuela · Florida Aero Sales Inc N22XPPitts S-1S · S/N 001Cancelled Dec 5, 1973 · Built 1973 · Pitts C H N80028Aerotek PITTS S-2A · S/N 2032Cancelled May 8, 1973 · Exported to Australia · Pitts Aviation Enterprises Inc N8501GCessna 150F · S/N 15062601Cancelled Feb 16, 1973 · Exported to Canada · Lyden Charles R N8853QAero Commander S2R · S/N 1553RCancelled Nov 15, 1972 · Bass Russell N3329TCessna 177 · S/N 17700629Cancelled Nov 14, 1972 · Barrett Paul C N8544ABeech A35 · S/N D-1966Cancelled Jan 14, 1972 · Causey Charles N100DCBeech 95-B55 (T42A) · S/N TC-1233Cancelled Oct 26, 1971 · Conley Richard J N8847QAero Commander S2R · S/N 1547RCancelled May 24, 1971 · Exported to South Africa · Bass Russell N8848QAero Commander S2R · S/N 1548RCancelled May 24, 1971 · Exported to South Africa · Bass Russell N8849QAero Commander S2R · S/N 1549RCancelled May 24, 1971 · Exported to South Africa · Bass Russell N8551DPiper PA-22-160 · S/N 22-5783Cancelled Jan 5, 1971 · Built 1957 · J L Hubbard Farms N52012Boeing A75L3 · S/N 75-4568Cancelled Jan 4, 1971 · Pitts Willie Mae N49785Boeing A75N1(PT17) · S/N 75-1631Cancelled Sep 23, 1970 · Willie Mae Pitts N9868CNorth American TB-25N · S/N 44-29919ACancelled May 19, 1970 · Aerographic Inc N5307TCessna 172E · S/N 172-51207Cancelled Sep 4, 1968 · Exported to Canada · South Dade Aviation Services Inc N7774ZPiper PA-25-235 · S/N 25-3971Cancelled Nov 7, 1966 · Exported to Costa Rica · Homestead Aviation Inc N7489ZPiper PA-25-235 · S/N 25-3506Cancelled Dec 3, 1965 · Exported to Nicaragua · Homestead Aviation Inc N7542ZPiper PA-25-235 · S/N 25-3588Cancelled Nov 17, 1965 · Homestead Aviation Inc N7463KPiper PA-20 · S/N 20-374Cancelled Aug 26, 1965 · Exported to Canada · Pruitt L H N7379ZPiper PA-25-235 · S/N 25-3336Cancelled Aug 3, 1965 · Exported to Nicaragua · Homestead Aviation Inc N6835ZPiper PA-25 · S/N 25-2502Cancelled Jul 30, 1965 · Exported to Colombia · Homestead Aviation Inc N7214ZPiper PA-25-235 · S/N 25-3126Cancelled Jul 20, 1965 · Exported to Costa Rica · Homestead Aviation Inc N3890PPiper PA-18-150 · S/N 18-4723Cancelled May 26, 1965 · James S Holland Jr N2795PPiper PA-18A · S/N 18-4430Cancelled May 21, 1965 · Holland James S N30905Piper J3C-65 · S/N 5190Cancelled May 21, 1965 · Built 1940 · Osborne Royce C N55420Boeing A75N1(PT17) · S/N 75-3742Cancelled May 21, 1965 · Bud Martens Aerial Dusting Service Inc N87891Piper J3C-65 · S/N 15509Cancelled May 20, 1965 · Airline Training Inc N7052ZPiper PA-25-235 · S/N 25-2820Cancelled Jul 14, 1964 · Exported to Dominican Republic · Built 1964 · Homestead Aviation Inc N4859EAeronca 7EC · S/N 7EC-692Cancelled May 4, 1959 · Homestead Air Force Base Aero Club N55416Boeing A75N1 · S/N 75-4586Cancelled Jun 30, 1957 · Built 1946 · Holley Dusting Service N2598BCessna 190 · S/N 7233Cancelled May 21, 1956 · Weiss W N66051Consolidated Vultee BT-13 · S/N 5128Cancelled Mar 14, 1956 · Built 1942 · Webb Shaw J III N64966Boeing B75N1 · S/N 75-6510Cancelled Feb 17, 1956 · Hall Aviation Co Inc N65213Consolidated Vultee BT-13A · S/N 6390Cancelled Feb 17, 1956 · Hall Aviation Inc N55583Boeing A75N1 · S/N 751439Cancelled Dec 22, 1955 · Hall Aviation Corp N53628Laister-Kauffman TG-4A · S/N 75Cancelled Nov 29, 1955 · Miller P Eugene N46543Boeing A75N1 · S/N 75-4423Cancelled Nov 22, 1955 · Built 1942 · Hall Aviation Inc N46861Fairchild M-62A · S/N 322-SLCancelled Nov 18, 1955 · Wilson Robert E & Richard T May N1110KLuscombe 8A · S/N 3837Cancelled Nov 2, 1955 · Van Tien Elizabeth K N49626Piper J3F-65 · S/N G-216Cancelled Oct 24, 1955 · Van Tien Elizabeth K N1625MBoeing N2S-5 · S/N 75-8566Cancelled Oct 17, 1955 · Harbert Patrick J N24835Piper J3L · S/N 3480Cancelled Oct 7, 1955 · Alfred J Schmitt Jr N1583NPiper J3C-65 · S/N 23115Cancelled Oct 5, 1955 · Reams Phillip D Jr N21801Piper J3F-65 · S/N 2597Cancelled Mar 18, 1955 · Bennett Miles N5082NBoeing E75 · S/N 75-5634Cancelled Jun 24, 1954 · Exported to Venezuela · Hall Aviation Co Inc N55392Boeing A75N1 · S/N 75-3234Cancelled Jun 24, 1954 · Exported to Venezuela · Hall Aviation Company Incorporated N55465Boeing A75N1 · S/N 75-1996Cancelled Jun 24, 1954 · Exported to Venezuela · Hall Aviation Company Inc N52846Boeing A75N1 · S/N 75-1723Cancelled Jun 18, 1954 · Exported to Venezuela · Built 1941 · Hall Aviation Co Inc N50140Boeing A75N1 · S/N 75-935Cancelled Dec 3, 1949 · Hall Aviation Co Inc

Back to Homestead, FL