Skip to content

Friendswood, TX

Cancelled registrations · 50

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

N8059WQuicksilver SPRINT · S/N E102Cancelled Jun 12, 2023 · Canup Billy Hank N4303GPiper PA-28RT-201T · S/N 28R-8331035Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 1983 · Garland Charles W N360MTTaylor Carmac D JR LANCAIR 360 · S/N 880-320-721Cancelled May 7, 2022 · Registration expired, pending cancellation · Built 2004 · Taylor Carmac D Jr N3265LCessna 172H · S/N 17256165Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 1967 · Rizzo Luke C N9268SBeech B19 · S/N MB-782Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1975 · Sholmire David P N45BMiller M-6 · S/N 1Cancelled Dec 8, 2020 · Registration expired, pending cancellation · Dean Dollens L N172TXCessna 172M · S/N 17266543Cancelled Mar 16, 2020 · Exported to Pakistan · Built 1976 · Ahmed Bushra A N10935Cessna 150L · S/N 15075149Cancelled Jan 31, 2020 · Registration expired, pending cancellation · Built 1973 · Cavanaugh Gerald R N232WSShober PITTS · S/N 1Cancelled Jan 31, 2020 · Registration expired, pending cancellation · Built 1966 · Dollens Larry Dean N9001ZJ. C. Reynolds JCR-1 · S/N 1Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Horn Rodney L N9860UGrumman American Avn. AA-5A · S/N AA5A0260Cancelled May 6, 2019 · Registration expired, pending cancellation · Built 1976 · Kantz Roger Travis N80632Cessna 172M · S/N 17266680Cancelled Apr 25, 2019 · Exported to Pakistan N6173GCessna 150K · S/N 15071673Cancelled Jan 9, 2019 · Registration expired, pending cancellation · Built 1969 · Cavanaugh Gerald N8086YPiper PA-34-200T · S/N 34-7970498Cancelled Dec 10, 2018 · Exported to Canada · Built 1979 · Cohen Lee J N66048Cessna 180K · S/N 18052913Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Built 1977 · Wood Denton A N37TXGlobe GC-1B · S/N 1208Cancelled Apr 26, 2018 · Built 1946 · Moses Ila G N777RSBeech 76 · S/N ME-47Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Built 1978 · Air Chase Inc N82BDMahan Hardaway QUICKIE Q2 · S/N 2546Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Built 1982 · Krch Gary D N22FRMikoyan Gurevich MIG 21 · S/N 02685144Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Built 1969 · Brader Luke D N898ACThomas James R MINI 500 · S/N 0057Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1996 · Thomas James R N5426LGrumman American Avn. AA-5 · S/N AA5-0326Cancelled May 15, 2017 · Registration expired, pending cancellation · Built 1973 · Carpentieri Stephen W N5737CCessna 170A · S/N 19691Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1950 · Moeller Earl R N67JGGarrett James C EUROPA XS · S/N A116Cancelled Jan 27, 2015 · Built 2001 · Garrett James C N7795FCessna 150F · S/N 15063895Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1966 · Mooney Frank X N4389HPiper PA-15 · S/N 15-173Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1948 · Robinson Stephen K N24039Taylorcraft BC-65 · S/N 1574Cancelled Sep 19, 2014 · Registration expired, pending cancellation · Built 1939 · Robinson Stephen K N45306Naval Aircraft Factory N3N-3 · S/N 1998Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1940 N27061Piper J3F-60 · S/N 4326Cancelled Aug 14, 2013 · Sale reported, canceled · Built 1940 N7007NBeech H35 · S/N D-4904Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1957 · Kennedy Steven R N609GKKowalchik Gerald BENSEN B-8 · S/N 001Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Kowalchik Gerald N707QCessna 180 · S/N 32531Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1956 · Williams Russell G N679CStinson 108-3 · S/N 108-3679Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1947 · C Air Inc N40289Hiller UH-12E · S/N 5096Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1979 · Legris Paul N45370Cessna 150M · S/N 15076880Cancelled May 23, 2012 · Exported to Argentina · Built 1975 · Hill J L N590Beech M35 · S/N D-6222Cancelled May 2, 2012 · First renewal notice · Built 1960 · Garrett James C N275KTWright Bruce M LANCAIR IV-P · S/N LIV-005-C1Cancelled Dec 15, 2011 · Exported to New Zealand · Built 2008 · Wright Bruce M N5526DBeech J35 · S/N D-5062Cancelled Jul 19, 2011 · Expired dealer · Built 1957 · Recreational Investments N350LLRaytheon B300 · S/N FL-157Cancelled Nov 23, 2010 · Exported to Mexico · Built 1997 · Kinsel Richard L Jr N2056WBeech V35 · S/N D-8040Cancelled Nov 3, 2006 · Built 1966 · Yates John D N38263Beech 76 · S/N ME-394Cancelled Jun 29, 2006 · Built 1981 · Air Chase Inc N1025JPiper J3C-65 · S/N 14439Cancelled Mar 20, 2006 · Snell Robert B N111JSSykes John H SKYBOLT · S/N 1Cancelled Jan 10, 2006 · Triennial form not returned · Built 1981 · Sykes John H N8144MBell 212 · S/N 30706Cancelled Feb 7, 2005 · Triennial form not returned · Built 1975 · Baker Felton M N1EAVanlaak James E KOLB FIRESTAR · S/N JV1Cancelled Nov 12, 1997 · Triennial form not returned · Vanlaak James E N8457WPiper PA-28-180 · S/N 282693Cancelled Aug 16, 1995 · Triennial form not returned · Walton Al N9503TCessna 210 · S/N 57303Cancelled Aug 26, 1992 · Hawkins Thomas R N6120XCessna U206G · S/N U20605822Cancelled Aug 22, 1983 · Clover Aero Inc N8467SCessna 182H · S/N 18256567Cancelled Nov 13, 1975 · Exported to Mexico · Built 1965 · White Christopher L N1241XMooney M20E · S/N 114Cancelled Sep 16, 1970 · Built 1964 · Wash Michael R/Duval Ronald/Lane William N36971Aeronca 65-TAC · S/N C2841TACancelled Nov 5, 1951 · Lindley Cecil

Back to Friendswood, TX