Cancelled registrations · 34

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 = 'PR' AND d.registrant_city = 'HATO REY' 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 = 'PR' AND d.registrant_city = 'HATO REY'
  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 = 'PR' AND d.registrant_city = 'HATO REY'
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.

N764ELLuciano Edison HALLMAN SPORSTER · S/N 91966Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 1999 · Luciano Cruz Edison A N20350Cessna 172M · S/N 17261213Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1972 · C&T Aviation Inc N13932Piper PA-23-250 · S/N 27-4564Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1971 · Visarondo Rafael A N141JPRodriguez Juan R B8M GIROPLANE · S/N 001Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Rodriguez Juan R N6901Bensen MODIFIED B-8M · S/N B8DJAM-1Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1968 · Chaves Carlos A N60913Cessna 150J · S/N 15070664Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1969 · Isla Grande Flying School & Service N52451Cessna 182P · S/N 18262618Cancelled Apr 2, 2013 · Registration expired, pending cancellation · Built 1973 · Perez Gustavo A Lopez N4795SPiper PA-32-260 · S/N 32-1169Cancelled Nov 27, 2012 · Sale reported, canceled · Built 1969 N343MCPiper PA-32-300 · S/N 32-7840180Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1978 · Cofresi Milton Jr N4502PPiper PA-23-250 · S/N 27-4Cancelled Nov 9, 2012 · Sale reported, canceled · Built 1959 N383FHFairchild Hiller FH-1100 · S/N 146Cancelled Jan 21, 2011 · Revoked, pending cancellation · Built 1968 · Office Of Transportation N3157XCessna 150G · S/N 15064557Cancelled May 21, 2003 · Second triennial mailing, no response · Built 1966 · Isla Grande Flg School Svc Corp N3158XCessna 150G · S/N 15064558Cancelled May 1, 2003 · Second triennial mailing, no response · Built 1966 · Isla Grande Flg School Svc Corp N46364Cessna 172K · S/N 17257215Cancelled May 1, 2003 · Second triennial mailing, no response · Built 1968 · Isla Grande Flg Sch & Svc Corp N61317Cessna 150J · S/N 15070960Cancelled May 1, 2003 · Second triennial mailing, no response · Built 1969 · Isla Grande N6479SCessna 150H · S/N 15067279Cancelled May 1, 2003 · Second triennial mailing, no response · Built 1967 · Isla Grande Flg School & Svc Corp N6523RAerostar International RAVEN S57-A · S/N S57A3017Cancelled Jan 7, 1998 · Triennial form not returned · International Balloons N178STPiper PA-46-310P · S/N 468408078Cancelled Feb 16, 1995 · Triennial form not returned · Engineered Products Co N6645Grumman G-164A · S/N 770Cancelled Nov 18, 1992 · Exported to Uruguay N68223Cessna 152 · S/N 15282197Cancelled Sep 29, 1992 · Triennial form not returned · Flight World Inc N7558ACessna A150M · S/N A1500733Cancelled Sep 28, 1992 · Triennial form not returned · Cloud Riders Aviation Inc N909CRCessna A150L · S/N A1500408Cancelled May 10, 1991 · Triennial form not returned · Reyes Carlos E N92135Cessna 172M · S/N 17261547Cancelled May 8, 1991 · Triennial form not returned · Isla Grande Flying School Service N202CRCessna 150M · S/N 15078970Cancelled May 6, 1991 · Triennial form not returned · Cloud Riders Aviation Inc N305CRPiper PA-23-250 · S/N 272253Cancelled May 3, 1991 · Triennial form not returned · Reyes Carlos E N61318Cessna 150J · S/N 15070961Cancelled May 3, 1991 · Triennial form not returned · Isla Grande Flg School And Svc Corp N4271QCessna 172L · S/N 17260171Cancelled Apr 30, 1991 · Triennial form not returned · Isla Grande Flyng School & Ser Corp N7268GCessna 172K · S/N 17258968Cancelled Dec 29, 1990 · Triennial form not returned · Isla Grande Flying Sch & Serv Corp N559PRCessna 150H · S/N 15067294Cancelled Oct 16, 1985 · Isla Grande Flying School & Service Corp N11207Cessna 150L · S/N 15075254Cancelled Jun 15, 1984 · Administratively canceled · Isla Grande Flg School & Serv Corp N6298UCessna U206G · S/N U206-05405Cancelled Dec 30, 1980 · Exported to Paraguay · Del Caribe Aviasur N5971ZPiper PA-22-108 · S/N 22-9843Cancelled Aug 18, 1971 · Isal Grande Flying School & Serv Corp N3159XCessna 150G · S/N 15064559Cancelled Nov 5, 1969 · Built 1966 · Isla Grande Flying School And Service Corporation N8372UCessna 172 · S/N 17252272Cancelled Feb 9, 1968 · Pennock Charles E

Back to Hato Rey, PR