Continental C145 series
Registered aircraft · 1,828
Aircraft with this engine in the FAA registry, by N-number.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE engine_model_code IN ('17012')
ORDER BY n_number"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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE engine_model_code IN ('17012')
ORDER BY n_numberRun 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.
N170JGivens Steve W · Pendleton, INN170JACrosby Kenneth R · Trapper Creek, AKN170JEBarrett John E · St Charles, ILN170JLGodes Terry J · Soldotna, AKN170JRRing John A · La Conner, WAN170JTSky West Aviation Inc Trustee · Albuquerque, NMN170JWStark David M · Merkel, TXN170KHFossa Joseph S · Essex, MAN170KMMarlow Properties LLC - Marlow Aviation LLC Series · Knoxville, TNN170LSchaible Peter J · Springfield, VAN170LEArends Brian H · Mahomet, ILN170MBCoffman Richard A II · Hernando, MSN170MSMidstate Aviation Inc · Ellensburg, WAFirst renewal noticeN170MWN88tg LLC · Fairbanks, AKN170PBFancher Scott · Granite Falls, WAN170PRHicks Arch A · Oxford, NCN170PSMcgavock Edward A · Columbus, WIN170PTSabos Anthony J · Bolingbrook, ILN170REBerbig Daniel J · Anchorage, AKN170RHBas Part Sales LLC · Greeley, CON170RKBelphegor LLC · Madison, WIN170RPDejesus Kennet J · Troy, OHN170RSWilson Benjamin A · Shawnee, KSN170SBMacbean Stanley F Trustee · Orem, UTN170SLSimmons Kenton L · Van Alstyne, TXN170STDow Jeff W · Port Hadlock, WAN170TCGammelin Robert · Alta, WYN170TPNorthrop John · Fairfield, CAFirst renewal noticeN170UWBlocher Kristyn A · Tumwater, WAN170VPocock Milne David · Cal Nev Ari, NVN170VWPratz Chris · Ellensburg, WAN170WRFinkel Charles M · Taylorsville, NCN170WSSikorski Bradley · Colorado Springs, CON170YPocock Milne D · Cal Nev Ari, NVN1712DRichter Ty G · Buffalo, SDN1714DBellenir Michael A · Mastic Beach, NYN1715DPulley Richard A · Chugiak, AKN1718DSwe3 LLC · Seattle, WAN1719DHurd Matthew · Recluse, WYN1720DDriver Jonathan S · Oakland Park, FLN1725DBeisheim Carrie E · Fort Calhoun, NEN1727DHall L Robert · La Verne, CAN1730DKeith R Layne · Oklahoma City, OKN1733DCessna 170 LLC · Idaho Falls, IDN1736DHoffman Drew A · Churubusco, INN173RJJohnston Ronald E · Seattle, WAN1743DCranton Larry J · Mesa, AZN1744DJones William H Trustee · Wenden, AZN1745DStuczynski Jason S · Justin, TXN1748DWilliams Bobby G · Simi Valley, CA
Back to Continental C145 series