Continental O-200A
Registered aircraft · 297
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 ('17404')
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 ('17404')
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.
N5058Bsa 12 LLC · Farmington Hills, MIN505ZWPresley Terry L · Rising Fawn, GAN514AKBearhawk Demo LLC · Fairview, OKN529GEEmerson Michael · Sioux Falls, SDN533Davis Gary W · Denton, TXN533ZRobinson Carl · Longview, TXN536CSHeaton Mark A · Gasquet, CAN5372PGreene David Trustee · Tyler, TXN5377Miller David P · Granite, ORN53EZLasley Russel · La Habra, CAN53WEEdson Robert Wayne · Hollister, MON5486XStrategic Aircraft Management LLC · Fairbanks, AKN55ZCBenson Barry I · Medway, MAN564SKOrback Michael J · Loveland, CON565DRegistration Pending · Kirtland, OHRegistration pendingN5793ELowe David M · Sacramento, KYN579CCLape Bruce A · Kasilof, AKN57WKStocker James M · Palmer, AKN58DMMoehn Dennis H · Oshkosh, WIN592Barksdale Air Racing LLC · Conroe, TXN5959ZCruikshank Bruce M · Castro Valley, CAN599CCYoung Erik A · Prescott, WAN601BDSafford Brad D · Waterloo, NEN601BFWilliams Steve · Salem, OHN601DReynolds Ernest D · West Glacier, MTN601DNGrumme William · Davie, FLN601ESAquino Wayne L · Lake Havasu City, AZN601FNMachin James T · Chewelah, WAN601WDDewane Ryan · Manitowoc, WIN601WWVirginia 601 Flyers LLC · Vesuvius, VAN601ZYKratz Bradley L · Indiana, PAN602WHShoemaker Gar · Cochranville, PAN6064JTreger Mark · Dallas, TXFirst renewal noticeN606CCMoore Thomas · Tecumseh, MIN60NGMcpherson Joseph Miller · Benson, AZN6113GPratt Aviation Services Inc · Anchorage, AKN615CBBrown William C · Bedias, TXN618SBTucker William F · Booneville, ARN618TETuskegee Eagles Of St Joseph Mo · Agency, MON619HCWallace Mark G · Dubuque, IAN623CBWalak William J · South Berwick, MEN624SGHeckerman Ted A · Canyon Lake, TXN625CCA Team Aviation Inc · Wilmington, DEN629WGFlack Kenneth J · Cortland, OHN632PMatlock Rodney D · Waco, NEN635LSSawyer Thomas L · Jacksonville, FLN637LSButts Michael P · Dartmouth, MAN638LSClark Billy B · Pride, LAN6393XMccarney Thomas R · Box Elder, SDN639LSRichardson Jesse D · Fort Wayne, IN
Back to Continental O-200A