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 aircraft_model_code IN ('2073704')
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 aircraft_model_code IN ('2073704')
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.
N3453TAircraft Evolution LLC · Miami, FLN3454TTears Gary S · Edmond, OKN3455TCornejo Jose Valente · Scottsdale, AZN3458TBrown Lance D · Cottonwood, CAN3460TBrowning Sean · Anchorage, AKN3462TJunck Kyle D · Branson, MON3465TRutherford Keith Allen · El Paso, TXN3468TMcn Systems LLC · Mount Airy, MDN3469TDahlen Jeffrey P · Devils Lake, NDN3470TPorte Elvis · Miami, FLFirst renewal noticeN3475TWitt Jerry D · Marana, AZN3478TGuzowski Richard G · Haydenville, MAN3479TRobbins Derick Mitchell Robbins · Freeport, FLN3480TMoffatt Thomas O Jr · Diberville, MSN3481TEstes Kenneth · Portland, ORN3482THaskell Thomas Edward · Georgetown, TXN3483TCalhoun Edward J · Whitney, NEN3484TCairo Jane LLC · Ponca City, OKN3489TBlue Skies Aviation LLC · Belfast, MEN3492TBell Anthony J · Avondale, AZN3496TSchwenk Franklin · Ben Wheeler, TXN3497TSeth Stephen L · Lake Jackson, TXN3498TSky View Aviation LLC · Longwood, FLN3507FAerial Oklahoma LLC · Oklahoma City, OKN370SNesbit Stephen W · Hemphill, TXN400LDreher Steve · Bettendorf, IAN40WNRider Rebecca L · Hyde Park, NYN449AGKershner Jordan · Malcolm, NEN467AT467at LLC · Frankfort, ILN526FRoush Heith · Cabot, ARN52KKVon Sternbert Nicholas Josef · Valencia, CAN651ECEagle Sky Patrol Inc · Deadwood, SDN652SRBracy Rodney E · Middleville, MIN653SRVertex Aviation Services LLC · Burlington, WAN657SRRm & Lp Ltd · Azalea, ORN658SRJung Sue Elaine · Lawton, OKN660SRAom Aircraft LLC · Orlando, FLN666RBOlam Holdings LLC · Honolulu, HIN6777TNeff Tj · Novato, CAN68VVWhite Mark E · Charleston, WVN692MADevine James W · Columbus, OHN72035Christiano Brett T · Pasco, WAN74PPBunnell Randy D · Blakesburg, IAN811HATate Grady · Harrisburg, NCN829BGGipson Robert E · Port Byron, ILN912VWThomas David A · Halifax, MA
Back to Cessna 177