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 ('59470')
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 ('59470')
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.
N364CCAdv Aviation LLC · Lewes, DEN364CFDoddridge Pamela L · Anacortes, WAN367EThrilltech LLC · Windermere, FLN368AFCubair LLC · North Palm Beach, FLN377CCCole-Tac LLC · Rapid City, SDN386BFTriple A Air LLC · Boca Raton, FLN390RTCornum Kory · Palisade, CON398CCJuliet Tango Flying Services LLC · Walnut Creek, CAN406DHRegistered aircraftN412CCStrub Mark · Arpin, WIN424YMcelroy Justin · Eudora, KSN4283CBanjo Boy LLC · Bozeman, MTN438CCBison LLC · Carefree, AZN451TDavenport Lon T · Livingston, TXN464CCCarbon Cub LLC · Columbus, MTN464LMPratt Lawrence · Minerva, NYN471CCCash James Lee Trustee · Granbury, TXN471LSFalcon Materials LLC · Orchard Park, NYN47XPRodenhouse Robert H · Port Orange, FLN484BYSwiatek Aviation LLC · Whitehall, MIN496CCHarman Jeffrey · Hiwassee, VAN508DMValiair Limited Co Trustee · Casper, WYN510BCBrian Investments LLC · Elizabethtown, NCN515JLRegistered aircraftN518SAPatterson Chad · Winthrop, WAN531WJHeitz Kenneth J · Boynton Beach, FLN534JWFlugzeug LLC · Rancho Santa Fe, CAN536CCPursuit Productions LLC · Santa Monica, CAN551DFComanche Maverick Air LLC · Houston, TXN55JVKehler Kelly · Saint Xavier, MTN584WTTrivette Michael · Charlotte, NCN603GBBusenitz Clinton Lee · Oral, SDN605GBEbright Sean E · Hasty, CON608SBButcher Owen J · Chugiak, AKN612CCBaron Phoenix Aviation LLC · Newport, RIN625GSWhiskey Tango Aviation LLC · Owasso, OKN64SLS3b Leasing LLC · Bangor, MEN67DEErickson Bruce R · Mack, CON682CCVintage Aircrafts LLC · Wilmington, DEN703AWOberdorfer Richard L · Prineville, ORN712CCB3 Cub LLC · Pensacola, FLN716PMBanys Christopher D Trustee · San Luis Obispo, CAN71XPPohoski James G · Lakeway, TXN71YBAndrews Richard · Houston, TXN722EDEcho Lemur LLC · Fort Worth, TXN723KWWemmering Field LLC · Laurel Fork, VAN7360PSolsvig Russell T · Tucson, AZN741KWGrand Aviation LLC · Coeur D Alene, IDN74544Davis Ronnie L · Trout Lake, WAN762TXDavis Hubert P Jr · San Antonio, TX
Back to Titan OX-340CC