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 ('2074246')
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 ('2074246')
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.
N310PZCardozo Armando J · Miami Gardens, FLN310RGRome Aviation LLC · Lakeland, TNN310SKAstroworld Travel LLC · Port Orange, FLN310TWHowe Phillip T · Oro Valley, AZN310VGGtc Services LLC · Ocala, FLN310WJAg N310wj LLC · South Salt Lake, UTN310ZFlyin' Dog Air LLC · Niceville, FLN314BBMarc Inc · Bolton, MSN314HBMarc Inc · Bolton, MSN3288MClute Kenneth N · Las Vegas, NVN3321MMaxray Aviation LLC · Ashland, OHN344AHAdams Flying Service Inc · Rayville, LAN3465GGv Air Inc · Medford, ORN3473GThayer John P · Columbus, GAN34WEWildes Thomas O · Chippewa Falls, WIN3517GGv Air Inc · Medford, ORN3587GAtor Robert W · Beach City, TXN358MNKeystone Aerial Surveys Inc · Philadelphia, PAN363RMMash Kity J LLC · Grand Rapids, MIN364NYMarc Inc · Bolton, MSN36862Linville Keith · Bend, ORN37268H & S Aircraft LLC · Lewes, DEN3731GMaxwell Truck & Equipment LLC · State College, PAN3796GSantos Aviation LLC · Chico, CAN4032CKrs Aerial Inc · Galloway, OHN4079CCalled To Care Residential Facility LLC · Avondale, AZN410WMFlying Life LLC · Middleburg, FLN41AYHunterdon Aviation Inc · Ringoes, NJN465DLKeystone Aerial Surveys Inc · Philadelphia, PAN466PJv Aviation LLC · Johnston, RIN4937JSwirsding David J · Chalfont, PAN4948AKeystone Aerial Surveys Inc · Philadelphia, PAN4949ASw Air LLC · Denver, CON4GKDalessandro Janet E · Park Falls, WIN5005JDowding Industries Inc · Eaton Rapids, MIN500AWMcnulty Kim E · Tehachapi, CAN500CHAchiro David P · Truckee, CAN5037JWoodland William B · Anchorage, AKN5038JKeystone Aerial Surveys Inc · Philadelphia, PAN5047JAir Transport Arm Of Christ Inc · Hurst, TXN5057JTopliff John G · Goodland, KSN5072CThomas Robert Allan Jr · Phoenix, AZN5083JKrs Aerial Inc · Galloway, OHN5111JValiair Ltd Co Trustee · Casper, WYN521ADBarringer Aviation LLC · Waxhaw, NCN5251CSherman Randolph · Beverly Hills, CAN5251JNarr Craig S · Fort Mohave, AZN5255CMcintosh Law Corp · Long Beach, CAFirst renewal noticeN5337CMarc Inc · Bolton, MSN5484JCaba Joseph · Covington, LA
Back to Cessna T310R