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 ('2072716')
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 ('2072716')
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.
N3116SRose David J · West Mansfield, OHN3118SMccormack Nicole E · Greenwood, CAN3119SFinch Michael J · Springfield, TNN3122STecumseh Skydiving School LLC · Tecumseh, MIN3123SGabin LLC · Tulsa, OKN3130SN3130s Corporation · Wilmington, DEN3133SMitchell Terry R · Tallahassee, FLN3136SSeiler Richard D · Bozeman, MTN3137SManley Robert E · Ferndale, WAN3140SLavell Michael J · Blue Mounds, WIN3141SValley Excavation And Grading Inc · Chatsworth, CAN3142SB&G Aircraft LLC · Greensboro, GAN3144SMyers Dathan Dh · Port Angeles, WAN3145SCorriher Ronald R · Mount Ulla, NCN3148SHauser Family Flying LLC · Mount Pleasant, PAN3151SThomas Darryl · Belfield, NDN3152SDavis Lee W · Burns, ORFirst renewal noticeN3158SBr Aviation LLC · Lewes, DEN315LAZalen LLC · Mercer Island, WAN3160STronier Paul C · Sparks, NVN3161SKrikorian John R · Fresno, CAN3162SEagle Aircraft LLC · Park City, UTN3163SLabrum Andrew K · Boise, IDN3167SLightning Bolt Aviation LLC · Bozeman, MTN316LSC M & N D Inc · Wilmington, DEN316SFDoc Aviation LLC · Ponca City, OKN3172SSterling Flyers LLC · Lehi, UTN3173SCortese Farm And Ranch Inc · Fort Sumner, NMFirst renewal noticeN3177SFreeman William R · Lenexa, KSN3181SWood David M · Purcellville, VAN3182SRyan Aviation Management LLC · Palm Coast, FLN3183SJohnson Richard · Winnebago, MNN3184SThrash Farms Inc · Pelahatchie, MSN3188SCrossman Charles · Rusk, TXN3189SMarvin Franz Interests Inc · Victoria, TXN3191SSkydive Harbor Springs Inc · Charlevoix, MIN3192SFrandsen Perry D · Sandy, UTN3193SHansen Arthur A · Lancaster, NYN3196SHistoricair Transport LLC · Midlothian, TXN3197SJarvis Jason O · Cresson, TXN3200SGreene James · Georgetown, TXN3201SBoder Eric T · Knoxville, TNN3207SSouthern Star Aviation LLC · El Campo, TXN3208SZirul James V · Kenai, AKN3210SGore Range Aviators LLC · Kremmling, CON3211SNoble Tom R · Winnsboro, TXN3213SRosengrants Matthew R · Walsh, CON3217SGrotbeck Christopher L · Albuquerque, NMN3219SYogodzinkski Steve M · Amberson, PAN3221SPropwash LLC · Mesquite, NV
Back to Cessna 182G