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 ('2072712')
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 ('2072712')
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.
N3016YWood James D · Mineral Bluff, GAN3018YGranger Airplane LLC · Granger, INN3020YJ & T Sullivan Farms Gp · Macon, TNN3021YBrancao Bryan A · Norco, CAN3023YMorgan Lee Blanchard · Albuquerque, NMN3024YTemple Curtis Lee · Porcupine, SDN3026YEpss LLC · Tavernier, FLN3028YStanton Tod J · Naperville, ILN3030YSamaniego Alejandro · Tucson, AZN3031YAir Repair Inc · Cleveland, MSN3035YWardlaw Consulting LLC · Truckee, CAN3036YPeterson Zachary E · Fargo, NDN3040YRight Rudder Flyers LLC · Columbia Falls, MTN3050YSmith Adam M · Holloman Afb, NMN3052YPingston Anthony · Plymouth, MIN3053YMudd Joseph A · Oakland, CAN3056YBardack Barry L Trustee · El Cajon, CAN3057YJjm Aviation LLC · Newport, NCN3064YStemper Pete L · Madison, SDN3067YRegistration Pending · Bluffdale, UTRegistration pendingN3070YPearce Andrew R · Raleigh, NCN3073YWf Aviation LLC · Bozeman, MTN3074YIronman Welding Inc · Rifle, CON3080YHd Aviation LLC · Birch Tree, MON3082YSappington Steven R · Redondo Beach, CAN3084YWasatch Industries LLC · Ogden, UTN3088YCathey Michael · Chattanooga, TNN3089YSymbiotic Assets LLC · Winnemucca, NVN3090YPine Tours LLC · Wilmington, DEN3092YGordon Robert A Jr · North Pole, AKN3093YRegistered aircraftN3095YBatenhorst Ag LLC · Dalhart, TXN3096YHerrman Robin A · Connell, WAN3097YKlenke Nathan D · Seward, NEN3099YPerkins Scott B · Thomas, OKN3100YWhalen John F · West Ossipee, NHN3101YJazzminate Inc · La Mesa, CAN3105YOakley James H · Spring Valley, CAN3107FPage Gordie R II · St George, UTN3107YSturgill Ricky G · Yucca Valley, CAN3113YYorkwind LLC · Gilford, NHN3116YGorrell Nena S · Madison, ALN3118YTeerlink Craig N Trustee · Cedar Hills, UTN3122YJti Management LLC · Colfax, WAN3123YAbecca Corporation · Jackson, MIN3125YOberdoerster Timothy L · Concord Township, OHN3126YOutdoor Freedom Inc · Camdenton, MON3130YScholz Mark W · Atchison, KSN3131YPaero Contracting LLC · Middletown, OHN3132YLampkin George G · Forney, TX
Back to Cessna 182E