Plane Fun Inc Tr Trustee
Earlier aircraft under this name · 42
Cancelled registrations that named this owner when they ended, newest first.
Query with SQL
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 = 'PLANE FUN INC TR TRUSTEE' OR list_contains(d.other_registrant_names, 'PLANE FUN INC TR TRUSTEE') 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 = 'PLANE FUN INC TR TRUSTEE' OR list_contains(d.other_registrant_names, 'PLANE FUN INC TR TRUSTEE') 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.
N23KYCessna P210N · S/N P21000447N25UCulver LFA · S/N 249N6005NFairchild Hiller FH-1100 · S/N 503N2257ZJensen STARDUSTER TOO · S/N SA-300-1N3811PCessna P210N · S/N P21000058N973MTCessna T210L · S/N 210-59915N3078ACessna 170B · S/N 25722N13JURimowa Flugzeugwerke F-13 · S/N 13-001N666HMCessna 340A · S/N 340A0373N976SFAerospatiale SA341G GAZELLE · S/N 1259N81MGCessna P210N · S/N P21000476N2HBCessna P210N · S/N P21000377N56846Piper PA-28-140 · S/N 28-7425051N754UMEagle R+D HELICYCLE · S/N 3-9BN13007Gehrmann Guido CH-7 KOMPRESS · S/N 053N17LYBeech F33 · S/N CD-1254N25LMManess Lynn PITTS S1S · S/N LM101N28RFFoidl Richard CH-7 KOMPRESS · S/N 38N369ZXMaule MT-7-235 · S/N 18044CN2931KHowell Phillip W OSPREY 2 · S/N 921N76249Cessna 120 · S/N 10654N561LCMaule M-7-235 · S/N 4054CN524CKAerostar S A YAK-52 · S/N 800802N142MECessna 172S · S/N 172S8425N111YKYakovlev/Chinnery YAK-11 · S/N 172521N70508Robinson Helicopter R66 · S/N 0701N60320Boeing A75N1(PT17) · S/N 75-883N3040CPiper PA-34-200T · S/N 34-7970022N150ZCReims CESSNA FRA150L · S/N 0149N246WAReims CESSNA F150G · S/N 0098N50UBWulf George PITTS S1-11X · S/N UB001N664MWPiper PA-28R-180 · S/N 28R30616N63HZFairchild Hiller FH-1100 · S/N 202N108MWSiai-Marchetti S.205-18R · S/N 104N5944JCessna 172N · S/N 17273846N84142Aerofab LAKE 250 · S/N 69N540PWGoeting Marcus M1-SPEED CRUISER · S/N 001N6774ZCessna 425 · S/N 425-0048N230JBPiper PA-18 · S/N 18-1883N55099Boeing IB75A · S/N 75-230N800YSReims CESSNA F150K · S/N 0587N61SGRotorway EXECUTIVE · S/N 3598
Back to Plane Fun Inc Tr Trustee