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 ('2072722')
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 ('2072722')
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.
N3476FDickens Charles L · Panama City Beach, FLN3477FFlying T LLC · Albuquerque, NMN3480FAltus Aircraft LLC · Taylor, TXFirst renewal noticeN3481FWells Garry L · Scotia, NEN3490FRegistered aircraftN3494FParadise Aviation LLC · Shoreline, WAN3498FHole In The Sky Aviation LLC · Dallas, TXN3502FLange Clifton E · Inez, TXN3504FBraden Peter S · Elizabethtown, KYN3505FWade Bradley S · Waterman, ILN3508FStephen G Dill Dvm LLC · Remington, VAN3510FHughes Ramzi Sanford · Alamo, NVN3512FNourbakhsh Illah R · Pittsburgh, PAN3514FSullivan Kelly J · Chandler, AZN3516FWhittock Tyson H · Anchorage, AKN3518FPortmann James R · St Louis Park, MNN3520FWood Forrest B · Cookson, OKN3525FR&R Aviation · Gunnison, CON3526FHaskett Steven E · Austin, TXN3527FTuorila Tony C · Anderson, SCN3528FFair Paul R · Vacaville, CAN3534FLackie Paul C · Melbourne, FLN3537FWatson James L · Burke, VAN3538FGospel Ministries International Inc · Collegedale, TNN3540FMcevoy Rex · Custer, SDN3543FKorngold Brandon L · Aliso Viejo, CAN3544FFercho Corliss Y · Glendive, MTN3546FN3546f LLC · Kitty Hawk, NCN3550FYoung Tom · Alton, MON3551FBursley Richard R · Phoenix, AZN3552FAirplanes Over Niagara LLC · Lewiston, NYN3555FStern Andrew · New York, NYN3560FAdams Chris · Braselton, GAN3562FHexd Medical · Rexburg, IDN3563FParker Layne T · Gustavus, AKN3565FKlosowski Mark Kevin · Lisbon, NYN3567FPbj Skylane LLC · Sparks, NVN3573FLutke Michael T · Kalamazoo, MIN3578FJag Flying Club Inc · Morgantown, WVN3579FRoberts David J · Missoula, MTN3585FArikara Properties LLC · Beulah, NDN3586FRegistration Pending · Phoenix, AZRegistration pendingN3587FStout Colt W · Bosque Farms, NMN3588FBlue Eagle Aviation LLC · Edmond, OKN3589FInmon Glen A · Pontotoc, MSN3592FArey Peter W · Great Falls, VAN3594FFirst Flight Corp · San Diego, CAN3597FLivesay John · Pana, ILN3PRShadow Air LLC · Mountain Home, ARN403ABItalio River Adventures LLC · Yakutat, AK
Back to Cessna 182J