Skip to content

Earlier aircraft under this name · 49

Cancelled registrations that named this owner when they ended, newest first.

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_name = 'PAN IMPORTS' OR list_contains(d.other_registrant_names, 'PAN IMPORTS') 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_name = 'PAN IMPORTS' OR list_contains(d.other_registrant_names, 'PAN IMPORTS')
  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_name = 'PAN IMPORTS' OR list_contains(d.other_registrant_names, 'PAN IMPORTS')
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.

N340JCessna 310D · S/N 39130Cancelled Sep 27, 1985 · Administratively canceled · Burbach Larry K, Bakersfield, CA N3812JCessna 150G · S/N 15065112Cancelled Sep 27, 1985 · Administratively canceled · Hutchison Johnny D, Allen, TX N35758Piper J5A · S/N 5-749Cancelled Sep 16, 1985 · Administratively canceled · Gobin Albert A, Newport, NH N3413ECessna 172N · S/N 17271536Cancelled Jul 25, 1985 · Administratively canceled · Pearson Aircraft Inc, Port Angeles, WA N3719PPiper PA-22-150 · S/N 22-3437Cancelled Mar 20, 1985 · Administratively canceled · Merritt Howard F, Largo, FL N36274Piper PA-34-200T · S/N 34-7870307Cancelled Mar 7, 1985 · Administratively canceled · Southwest Skyways Inc, Torrance, CA N37174Cessna 414A · S/N 414A0252Cancelled Feb 14, 1985 · Administratively canceled · Gimbel Aviation Inc, Jackson, MI N3244WPiper PA-32-260 · S/N 32-60Cancelled Jan 8, 1985 · Administratively canceled · Fayssoux Richard Jr, Greensboro, NC N34452Cessna 177B · S/N 17701813Cancelled Jan 8, 1985 · Administratively canceled · Pylate Jimmy, Eudora, AR N35520Cessna 172I · S/N 17256811Cancelled Jan 8, 1985 · Administratively canceled · Michaels B J, Goodwin, AR N33866Piper PA-34-200T · S/N 34-7570173Cancelled Dec 20, 1984 · Administratively canceled · Crocker National Bank, Fullerton, CA N3150UCessna 182F · S/N 18254550Cancelled Dec 11, 1984 · Administratively canceled · Weber Harry L, Ridgefield, CT N32329Piper PA-28-140 · S/N 28-7525051Cancelled Dec 11, 1984 · Administratively canceled · G & S Survey Inc, Sand Springs, OK N36782Piper PA-32RT-300T · S/N 32R-7887077Cancelled Dec 11, 1984 · Administratively canceled · Hill Aircraft & Lsg Corp, Atlanta, GA N36946Cessna 414A · S/N 414A0489Cancelled Dec 11, 1984 · Administratively canceled · Stephen B Colwell Co, Mammoth Lakes, CA N90435Hughes 369HS · S/N 340575SCancelled Dec 11, 1984 · Administratively canceled · Andrea C Fishing Corp, San Diego, CA N3181Eaa BIPLANE · S/N BR-1Cancelled Oct 25, 1984 · Administratively canceled · Day George A, Brownwood, TX N33KCCessna 421 · S/N 421-0026Cancelled Oct 25, 1984 · Administratively canceled · Atlas Plastics Corporation, Mcminnville, OR N3820FGreat Lakes 2T-1A-2 · S/N 0788Cancelled Oct 25, 1984 · Administratively canceled · Keith Aviation Inc, Shawnee, OK N34370Cessna 177B · S/N 17701782Cancelled Oct 5, 1984 · Administratively canceled · Lindenberg Martin, Spring Valley, NY N3713JCessna 150G · S/N 15065013Cancelled Oct 5, 1984 · Administratively canceled · Obrien James P, Stormville, NY N32750Piper PA-32-260 · S/N 32-7500008Cancelled Oct 3, 1984 · Administratively canceled · Basco Flying Service Inc, Pottstown, PA N35206Piper PA-31-350 · S/N 31-7952193Cancelled Oct 3, 1984 · Administratively canceled · Southcentral Air Inc, Kenai, AK N3572WPiper PA-32-260 · S/N 32-464Cancelled Sep 6, 1984 · Administratively canceled · Antilles American Seafood Corp, St Maarteen N37USPiccard AX-6 · S/N 637Cancelled Aug 15, 1984 · Administratively canceled · Pruett Lee T, Austin, TX N35TABell 206B · S/N 1479Cancelled Aug 11, 1984 · Administratively canceled · Air Metro Helicopters Inc, New City, NY N34627Cessna 177B · S/N 17701908Cancelled Aug 6, 1984 · Administratively canceled · Storey Paul E, Woodstock, GA N3458SCessna 182H · S/N 18255858Cancelled Aug 2, 1984 · Administratively canceled · Klabunde Harold, Emmet, ND N32BPPulver BREEZY RLU-1 · S/N 30R4Cancelled Aug 1, 1984 · Administratively canceled · Pulver Robert E, Otsego, MI N32561Smith Michael D ULTRALITE J3-2 · S/N 0002Cancelled Jul 21, 1984 · Administratively canceled · Smith Michael D, Huntington Beach, CA N33658Bowlus BSA-100 · S/N 102Cancelled Jul 21, 1984 · Administratively canceled · Stiglmeier Herman J, Kila Kauarl, HI N3184WBeech E-55 · S/N TE-962Cancelled Jul 11, 1984 · Administratively canceled · Glasscock C Gus Jr, Columbus, TX N33678Douglas DC3-G202A · S/N 4133Cancelled Jul 11, 1984 · Administratively canceled · Stoltzfus Chris D, Coatesville, PA N3616CSchweizer SGS 1-36 · S/N 6Cancelled Jul 11, 1984 · Administratively canceled · Smith Benny R, Santa Rosa, CA N377TSmittys Termite JT-1 · S/N 1TCancelled Jul 11, 1984 · Administratively canceled · Eaa Aviation Foundation Inc, Franklin, WI N3500MBell 206B · S/N 473Cancelled Jul 6, 1984 · Administratively canceled · Island Helicopters Corporation, Garden City, NY N3556ZPiper PA-22-150 · S/N 22-7467Cancelled Jul 6, 1984 · Administratively canceled · Mills Norman E, Burlington, MA N3484APiper PA-22 · S/N 22-1754Cancelled Jul 3, 1984 · Administratively canceled · Jackson Leonard Jr, Carson, CA N35733Piper J4E · S/N 4-1403Cancelled Jul 3, 1984 · Administratively canceled · Fetting George P, St Petersburg, FL N3580DPiper PA-31-350 · S/N 31-8052084Cancelled Jul 3, 1984 · Administratively canceled · Triangle T Leasing, San Antonio, TX N3226VBeech 35 · S/N D-669Cancelled Jun 15, 1984 · Administratively canceled · Kirkham George D, Sunnyvale, CA N3335JCessna 150G · S/N 15066035Cancelled Jun 15, 1984 · Administratively canceled · Tallman Donald W, Kansas City, KS N3353GSchleicher K 8 B · S/N 991Cancelled Jun 15, 1984 · Administratively canceled · Five Eight Club, Columbia, MD N3421TCessna 177 · S/N 17700721Cancelled Jun 15, 1984 · Administratively canceled · Barron Rufus E, Graceville, FL N35073Cessna 177B · S/N 17702189Cancelled Jun 15, 1984 · Administratively canceled · Cloud 9 Flying Club, Kansas City, MO N3572RBeech A23 · S/N M-755Cancelled Jun 15, 1984 · Administratively canceled · Lokey Charles F, Aiken, SC N3194RCessna 182L · S/N 18258594Cancelled May 30, 1984 · Administratively canceled · Styhr Karsten H, Rancho Palos Verde, CA N361VDehavilland DHC-6 TWIN OTTER · S/N 361Cancelled May 30, 1984 · Administratively canceled · 61 Victor Associates, Tucson, AZ N34266Schweizer SGS 1-35 · S/N 46Cancelled Aug 16, 1980 · Administratively canceled · Freedy Allan L, Aurora, IL

Back to Pan Imports