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 ('2072434')
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 ('2072434')
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.
N75951Newman James D · El Cajon, CAN75955Belgarde Monte G · Butte, MTN75956Millennium Aviation Group LLC · Wallace, NCN75967Ace Of Spades Aviation LLC · Las Vegas, NVN75971Price Ronald Anthony · Deer Park, WAN75972Aircraft Resource Center Inc · Lakeville, MNN75974733et LLC · Columbus, OHN75976Suburban Aircraft Leasing And Sales LLC · Sylvania, OHN75982Schurr Frank J · Las Vegas, NVN75985Pitt Patrick L · Ephrata, WAN75ERFaulkner John · Urbana, OHN75TCMorales Luis · Florence, ORN76015Aldea Aviation Partners LLC · Encino, CAN76016Cape Fear Aviation Maintenance LLC · Fayetteville, NCFirst renewal noticeN76019Grimley Robert J · Palermo, NJN76032Brown Jeffrey A · Wellington, ALN76044Williams Cecil R · Clarksville, TNN76047Registration Pending · Muskogee, OKRegistration pendingN7604FKcsi Aerial Patrol Inc · Bakersfield, CAN76053Ape LLC · Birmingham, ALN76056Bormuth Alan R · Morganton, NCN7605FPromise Road Aviation Inc · Pendleton, INN76076Elite Airplanes LLC · Fort Myers, FLN7607EPowerbelt LLC · Glendale, CAN7607FRolinski Alexander S · Deland, FLN7608FAj Mush LLC · Dearborn, MIN76091Riverside Flight Academy Inc · Riverside, CAN7609FKomberec Eric R · Kalispell, MTN7611FGeneral Aviation Support Corp · Rosamond, CAN767CDTyler Flyers Inc · Tyler, TXN767CGMindy Limited LLC · Muscatine, IAN76LCHacienda Hills Skyhawk LLC · Laveen, AZN772RAKehmeyer Aviation LLC · Bronson, MIN774MGPs Aviation Inc · Jackson, MNN775GTToole Gregory Keith · Humble, TXN775RTG & M Aircraft Inc · Wheat Ridge, CON7791H2 Aviation LLC · Middlebury, INN77ERFrech Betty J Trustee · Columbia, MON784GTMarianas Air Transfer Inc · Tinian, MPN784REsmaili Farid · Woodstock, VAN78763Steve'S Landavator Service LLC · Oley, PAN787ATCentral Virginia Flyers Flying Club Inc · Glen Allen, VAN787WTSemper Supra Air LLC · Ashland City, TNN788MCRoberts James A · Edina, MNN789CEBond Brent L · Clearwater, KSN79162Fink Roland Jr · Berlin, MDN79323Carstairs Energy Inc · Los Osos, CAN79514Galaxy Aviation LLC · Nantucket, MAN797RJSeven 4 Zulu LLC · San Diego, CAN7DGElizabeth City State University · Elizabeth City, NC
Back to Cessna 172N