Skip to content

Cancelled registrations · 1,071

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 = 'OK' AND d.registrant_city = 'TULSA' 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 = 'OK' AND d.registrant_city = 'TULSA'
  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 = 'OK' AND d.registrant_city = 'TULSA'
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.

N7618NCessna T210N · S/N 21063245Cancelled May 8, 2013 · Registration expired, pending cancellation · Financial Analysts Inc N7019WPiper PA-28-180 · S/N 28-700Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1962 · Felmlee Richard A N7124GCessna 172K · S/N 17258824Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1969 · Romans Reta Jean N6534HCessna 172M · S/N 17265478Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1975 · Walker Lynn W N63930Cessna 172P · S/N 17275496Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1981 · Bow Pipe Line N57149Raven S55A · S/N S55A-677Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1980 · Bagby James Dale N5797QMooney M20E · S/N 757Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1965 · Pense Irvin D N5591YPiper PA-23-250 · S/N 27-2698Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1964 · Murphy Joe D N5502VBellanca 8KCAB · S/N 410-78Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1978 · Nuss Alan E DBA N32842Piper J3L-65 · S/N 5652Cancelled Apr 16, 2013 · Registration expired, pending cancellation · Built 1940 · Romans Gleason N3357RCessna 182L · S/N 18258657Cancelled Apr 16, 2013 · Registration expired, pending cancellation · Built 1967 · Mitchell Loyd E N47526Cessna 152 · S/N 15283232Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1979 · Ross School Of Aviation Inc N9049RSkyhopper 10 · S/N L1Cancelled Apr 9, 2013 · Sale reported, canceled · Built 1966 N93538Cessna 152 · S/N 15285511Cancelled Mar 25, 2013 · Sale reported, canceled · Built 1982 N9850CCessna T303 · S/N T30300219Cancelled Mar 25, 2013 · Sale reported, canceled · Built 1983 N9064DHughes TH-55A · S/N 65-18270Cancelled Mar 18, 2013 · Sale reported, canceled N93043Douglas C-47A · S/N 43-48073Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1943 N4239DBeech G35 · S/N D-4452Cancelled Mar 11, 2013 · Registration expired, pending cancellation · Built 1956 · Jones Clifford E N345MTCessna 177B · S/N 17702031Cancelled Mar 7, 2013 · Registration expired, pending cancellation · Built 1973 · N345mt LLC N6520ACessna T210N · S/N 21063543Cancelled Mar 6, 2013 · Exported to Mexico · Built 1979 · Dan Howard Aircraft Sales Inc N706DMMitsubishi MU-2B · S/N 038Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1968 N7844ZCessna 150C · S/N 15059944Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1963 N82123Piper PA-31T · S/N 31T-7720030Cancelled Feb 27, 2013 · Sale reported, canceled N9210CCessna 180 · S/N 31309Cancelled Feb 26, 2013 · Revoked, canceled · Built 1954 · Aerial Photo Service Inc N3622YCessna 210C · S/N 21058122Cancelled Feb 13, 2013 · Exported to Mexico · Built 1963 · Dan Howard Aircraft Sales Inc N319BFRockwell International 690C · S/N 11675Cancelled Feb 8, 2013 · Sale reported, pending cancellation N125QBKearbey Jack C SE5A · S/N D3540Cancelled Feb 7, 2013 · Exported to Germany · Kearbey Jack C N15697Piper PA-28-180 · S/N 28-7305122Cancelled Jan 31, 2013 · Registration expired, pending cancellation · Built 1972 · Wiley Clyde H N6677NCessna T210N · S/N 21063143Cancelled Jan 14, 2013 · Exported to Mexico · Built 1978 · Dan Howard Aircraft Sales Inc N492FCessna 180B · S/N 50602Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Built 1959 · Myers Gerald R N720AXMcdonnell-Douglas DC-10-30 · S/N 48252Cancelled Dec 18, 2012 · First renewal notice · Omni Dc-10 Leasing LLC N167SCGroom Garry SPARROWHAWK · S/N SH20040004KCancelled Dec 13, 2012 · Registration expired, pending cancellation · Built 2006 · Groom Garry P N5131GCessna 150H · S/N 15069284Cancelled Dec 11, 2012 · Sale reported, canceled · Built 1968 N2682WMooney M20C · S/N 3320Cancelled Nov 29, 2012 · Exported to Argentina · Built 1966 · Dan Howard Aircraft Sales Inc N4692TSchleicher KA 7 · S/N 773Cancelled Nov 27, 2012 · Sale reported, canceled · Built 1964 N9609ZCessna U206G · S/N U20606571Cancelled Nov 27, 2012 · Sale reported, pending cancellation · Built 1982 N9860FBell 47D1 · S/N 51-13898Cancelled Nov 26, 2012 · Sale reported, pending cancellation N4183SBeech V35B · S/N D-9758Cancelled Nov 20, 2012 · Registration expired, pending cancellation · Built 1975 · Frank'S Aircraft Inc N40828Piper J3L-65 · S/N 7532Cancelled Nov 19, 2012 · Registration expired, pending cancellation · Built 1941 · Brown Aviation Inc N9118GCessna 182N · S/N 18260658Cancelled Nov 19, 2012 · Sale reported, pending cancellation · Built 1971 N9213TPiper PA-38-112 · S/N 38-78A0277Cancelled Nov 19, 2012 · Sale reported, pending cancellation · Built 1978 N30815Cessna 210L · S/N 21059966Cancelled Nov 16, 2012 · Exported to Paraguay · Built 1973 · Dan Howard Aircraft Sales Inc N17JGAero Commander 680W · S/N 1802-24Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1968 · Tulsa Technology Center School District No 18 N29195Cessna TU206C · S/N U206-1157Cancelled Oct 19, 2012 · Registration expired, pending cancellation · Built 1968 · Meyers Gerald R N73722North American 047B · S/N 51-1025Cancelled Oct 16, 2012 · Sale reported, pending cancellation · Built 1951 N1UXKoch J Michael ROTEC-RALLY 3 · S/N 64700Cancelled Oct 11, 2012 · Registration expired, pending cancellation · Ultraflight Inc N6031ZPiper PA-25 · S/N 25-38Cancelled Oct 2, 2012 · Sale reported, pending cancellation · Built 1959 N3233CBeech E35 · S/N D-3898Cancelled Sep 27, 2012 · Registration expired, pending cancellation · Built 1954 · Long Philip Lowell Trustee N3MFHawker Siddeley DH-125 · S/N 25093Cancelled Sep 25, 2012 · Registration expired, pending cancellation · Built 1966 · Howard Ron W N2817GBeech C-45G · S/N A-66Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Built 1951 · Western Venture Capital Corp

Back to Tulsa, OK