North Hollywood, CA
Cancelled registrations · 187
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_state = 'CA' AND d.registrant_city = 'NORTH HOLLYWOOD' 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 = 'CA' AND d.registrant_city = 'NORTH HOLLYWOOD' 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.
N61773Cessna 172M · S/N 17264790N917AULockheed P-3A · S/N 150510N724MAGrumman S2F · S/N 136724N327MAGrumman S2F-1 · S/N 136723N743MAGrumman S2F · S/N 136743N755AKKalents Armen COZY MK-IV · S/N MK-1065N713TSFreefly ALTA · S/N 716500N500EPDJI INSPIRE 2 · S/N 09YDE6UL040173N151WRBalz Gunther W TM-1 THUNDER MUSTANG · S/N 24N5734WPiper PA-28-150 · S/N 28-1403N4095BAeronca 15AC · S/N 15AC-420N780DYFreefly Systems ALTA 8 · S/N 685055N3203XCessna 150G · S/N 15064603N8688TCessna 182C · S/N 52588N23552Aeronca 65-C · S/N C5109N659RSDJI SPREADING WINGS S900 · S/N 0370020498N659SSDJI SPREADING WINGS S900 · S/N 0370061076N659TRDJI INSPIRE 1 PRO · S/N W21ACI16011979N71664Luscombe 8A · S/N 3091N631ZJDonovan Davis CINESTAR 8 · S/N APCS8-001N627FSDonovan Davis SS1 · S/N SS000001N6318FDonovan Davis 280MM MINI MOJO · S/N AP280MOJO-001N631NSDJI INSPIRE 1 PRO · S/N W21ACI16011197N631USDJI S900/A2 · S/N CD91E25CBFE0D2D93617984441FE2CN628CWDJI PHANTOM 2 · S/N PH645189992N617UYDonovan Davis SS2 · S/N SS000002N617TZDJI PHANTOM 2 · S/N PH636159944N612TBAerial Freaks MOJO 280 · S/N MJ000001N587NJDJI INSPIRE 1 · S/N W13DCB14020599N64243Cessna 172M · S/N 17265117N6253GCessna 172N · S/N 17273582N714VTCessna 152 · S/N 15279473N53502Taylorcraft DCO-65 · S/N 5943N33AXOleksiy Zayika MR 14 · S/N 14001N33197Piper J4A · S/N 4-1352N81100Funk B75L · S/N 230N23066Luscombe 8A · S/N 990N911SPIsrael Aircraft Industries 1124 · S/N 244N9641CNorth American B-25J · S/N 4430010AN72754Cessna 140 · S/N 9937N7980FCessna 150F · S/N 15064080N889LBCessna 172S · S/N 172S9889N2565LCessna 172H · S/N 17255765N4649LCessna 152 · S/N 15284206N118FAReinstra/Mcdonnel Douglas F-18A · S/N 161973N688EADouglas DC3 · S/N 12943N66957Fairchild M-62A · S/N 2103AEN5982XBrantly B-2 · S/N 126N542RBKarnes David MINI-MAX · S/N 335N800STDominion SKYTRADER 800 · S/N PROTOTYPE
Back to North Hollywood, CA