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 ('2072420')
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 ('2072420')
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.
N4427LHatter Ronnie A · Newcastle, OKN442PGLuedders & Reed Inc · Pawnee City, NEN4430LDunn Michael P · Queen Creek, AZN4436LLehman Bradley R · Onsted, MIN4437LThomas John · Lees Summit, MON4438LHarvey Jason Kyle · Glendale, AZN4441LKwon Andrew W · Tujunga, CAN4442LSchoepflin Robert D · Palouse, WAN4443LHenderson Michael Trustee · Whitman, NEN4446LC And T Aviation Inc · Madera, CAN4448LPuertolas Pascual G · Cobb, CAN4450LSouth Side Corp · Cody, NEN4452LVenhuizen Todd M · Queen Creek, AZN4453LByers Keith W · Ruffs Dale, PAN4455LLeiser Harry W · Rome, PAN4460LRegistration Pending · Saint Petersburg, FLRegistration pendingN4461LMerdan Curtis D · Shady Shores, TXN4462LAndresen Paul S · Chandler, AZN4467LDavis Christopher V · Green Forest, ARN4468LTurner Samuel C · Trapper Creek, AKN4469LLynes Carl Andrew · Las Vegas, NVN4473LWestbrook Lavelle D · Taylorsville, MSN4474LBlanco Andres A Socarras · Lajas, PRN4475LAlfonso Ramos · Dallas, TXN4476LP&N Corp · Marion, IAN4477LEdgin Jim · Aptos, CAN4479LGravenstede Nelson F · Newton, NJN4483LRogers Ross E · Udall, KSN4484LMifflintown Airport Aero Club Inc · Loysville, PAN4494LJ&S Aviation Services LLC · Hastings, NEN4495LBlue Wings LLC · Brecksville, OHN4496LHotel Charlie LLC · Lewes, DEN4499LKilo Charlie LLC · Lenexa, KSN4600LRitchie Edwin J · Katonah, NYN4610LIson Ronald B · New Braunfels, TXN4611LNutsch.Com LLC · Independence, ORN4612LGrayson Clayton C · Hillsboro, TXN4613LMcalpin Timothy P · Phoenix, AZN4614LDowell Roy · Burns, ORN4615LBatie Matt G · Black Hawk, SDN4617LKellam Robert L · Georgetown, TXN4618LCutlip Eugene F · Astoria, ORN4619LGrey Eagle Photography LLC · Battle Ground, WAN4621LOstrowski Frederick J · Otsego, MNN4622LChp Group LLC · Semmes, ALN4624LSfc LLC · Minden, NEN4626LBartel David P Sr · Crossville, TNN4629LKroeker David B · Aumsville, ORN4630LSpencer Gary Dale · Jones, OKN4631LBalla Steve · Fallbrook, CA
Back to Cessna 172G