Skip to content

Cancelled registrations · 608

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 = 'TX' AND d.registrant_city = 'AUSTIN' 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 = 'TX' AND d.registrant_city = 'AUSTIN'
  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 = 'TX' AND d.registrant_city = 'AUSTIN'
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.

N6306LAmerican AA-1A · S/N AA1A-0306Cancelled Dec 18, 2014 · Registration expired, pending cancellation · Built 1971 · Salazar Delfin Jr N2805XCessna 177 · S/N 17700205Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1967 · Mccarthy William O N884DGulfstream AM Corp Comm Div 690C · S/N 11696Cancelled Dec 3, 2014 · Registration expired, pending cancellation · Built 1981 · Aerosales And Services Inc N8961MBeech D95A · S/N TD-561Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1964 · Capitol Aviation Inc N7785FCessna 150F · S/N 15063885Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1966 · Brown Eugene A N6924NMooney M20C · S/N 680182Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1968 · B & B N105GBAerospatiale AS350B · S/N 1362Cancelled Nov 12, 2014 · Third renewal notice · Built 1981 · Byram Aviation Ltd N33541Piper PA-34-200T · S/N 34-7570130Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1975 · Cotton W B N3487NMooney M20F · S/N 680069Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1967 · Stanton Frank W N3109LCessna 310J · S/N 310J0109Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1965 · Wimberly Marion Lee N3232RCessna 411 · S/N 411-0232Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1966 · Star Aviation Inc N23285Piper PA-38-112 · S/N 38-81A0110Cancelled Sep 19, 2014 · Registration expired, pending cancellation · Built 1981 · Kennedy Aloma J N77KYExtra Flugzeugbau EA-400 · S/N 17Cancelled Sep 9, 2014 · Exported to Czech Republic · Built 2001 · Tornbjerg Thomas N1386Scooter ITCHIBAN SKOOTA · S/N FS-16Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1973 · Spencer Richard V N88BDCessna 150H · S/N 15068704Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1968 · Hanson Wallace G N59VAAbbey Victor G VANS RV9-A · S/N 90928Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 2006 · Hatch Aaron M N8412EBell 47J · S/N 1800Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1959 · Air Dreams N6576WAerostar International RX-7 · S/N RX7-3158Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1988 · Miller Brett A N92CLLangerud Clarence SONERAI II · S/N 521Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1982 · Langerud Clarence I N9627VCessna 172M · S/N 17264407Cancelled Sep 11, 2013 · Registration expired, pending cancellation · Built 1974 · Gloris Robert James N25479Quicksilver SPRINT · S/N E374Cancelled Aug 28, 2013 · Sale reported, canceled · Built 2004 N4571ZPiper PA-22-108 · S/N 22-8080Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1961 N5117RBeech C23 · S/N M-1946Cancelled Aug 7, 2013 · Exported to Canada · Built 1977 · Ramirez Arturo A N6293BAero Commander 680 · S/N 680-627-253Cancelled Aug 5, 2013 · Revoked, canceled · Built 1958 · Owens Harlan Thomas N3049ZPiper PA-22-160 · S/N 22-7003Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1959 · Dutton Larry D N800REBeech 300 · S/N FA-7Cancelled Jul 24, 2013 · Built 1984 · Aircraft Properties LLC N91TSPiper PA-31T · S/N 31T8020050Cancelled Jul 24, 2013 · Built 1980 · Aircraft Properties LLC N82CJJohnston Carlin J LONG EZ · S/N 377Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1983 · Johnston J Carlin N4886PPiper PA-23-250 · S/N 27-470Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1961 · Roberts Paul D N518ECDiseker Charles M JR GLASAIR RG · S/N 518Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Dieseker Charles M Jr N5159BHowell John Reid JR CAPELLA · S/N 88113503Cancelled Jul 15, 2013 · Registration expired, pending cancellation · Howell John R Jr N5163FHarvey Holton O CAPELLA CLASSIC · S/N 88-701-447Cancelled Jul 15, 2013 · Registration expired, pending cancellation · Harvey Holton O N1233RRaven S55A · S/N S55A-357Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1977 · Locke Robert M N71557Luscombe 8A · S/N 2984Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1946 · Neely Gary L N9117XCessna 182D · S/N 18253517Cancelled Jul 3, 2013 · Registration expired, pending cancellation · Built 1961 · Hudson Mark E N5684MRaven S55A · S/N S55A-522Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1979 · Jutontri Inc N7135UMooney M20E · S/N 374Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1964 N3668BBeech B50 · S/N CH-61Cancelled Jun 12, 2013 · Sale reported, canceled · Built 1954 N37TCBeech E18S · S/N BA-290Cancelled Jun 12, 2013 · Sale reported, canceled · Built 1957 N27ECCullen Edward R SCORPION TOO · S/N 2113Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1982 · Robertson James A N4421FCessna 421C · S/N 421C0693Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1979 · Aircraft Systems & Manufacturing Inc N4018CRaven S55A · S/N S55A-825Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1981 · Austin Aeronauts Inc N3870WBeech 77 · S/N WA-261Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1981 · Juliano Samuel P N9063ZRobinson Helicopter R22 · S/N 0147Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1981 · Tejas Helicopters N9073PPiper PA-24-260 · S/N 24-4542Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1966 · Comanche Trails Inc N7992FCessna 150F · S/N 15064092Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1966 · Coaster G Bain DBA N8121EMooney M20A · S/N 1392Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1959 · Texas Commercial Insurance Agcy Inc N7709ECessna 150 · S/N 17509Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1959 · Danielson Joe N N6436NCessna T210N · S/N 21063012Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1978 · Forman Wilson N64419Cessna 172M · S/N 17265215Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Brixa Inc

Back to Austin, TX