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 ('2072704')
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 ('2072704')
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.
N5855BCudahy J Patrick · Bayside, CAN5857BObrien Terence · Bonney Lake, WAN5859BGrant Marsall M · Truckee, CAN5862BJac & Phill Corp · San Ysidro, CAN5863BBales Charles F · Altadena, CAN5864BKavanaugh James M · Gilbert, AZN5866BAir-O-Drome Aviation LLC · Caldwell, IDN5869BGoodman David · Yuba City, CAN5870BSkylane 70b LLC · Pine, CON5874BTravis Clay · Hopkinsville, KYN5875BFerguson Bruce W · Fort Peck, MTN5878BRobel Timothy R · Yakima, WAN5882BValley Air Inc · Natchitoches, LAFirst renewal noticeN5885BGottlieb Kevin L · Anchorage, AKN5886BSchramm Craig O · Fenton, MIN5887BRedden Timothy Ray · Citrus Heights, CAN5889BLeitz Steven C · Cathlamet, WAN5890BKilo Aviation LLC · East Peoria, ILN5894BFischer Alfred M DBA · Genoa City, WIN5899BRi Skydiving Aircraft LLC · Middletown, RIN5900BEnvi Adventures LLC · Troutdale, ORN5903BAbidance Inc · Winthrop, WAN5904B98x LLC · Caddo Mills, TXN5907BWarner Aric D · Rosamond, CAN5908BLifland Kenneth D · Mckinney, TXN5911BKatzer Jamin · Frederick, CON5912BPrice Rand S · Casper, WYN5914BStrong Brian DBA · Southport, NCN5915BTaylor Scott G · Draper, UTN5917BHauser Nathan S · Newark, DEN5919BBell Ian E · Rapid City, SDN5922BLitton John C · Quartz Hill, CAN5923BWilson Phillip K · Waukesha, WIN5924BZarinnia Anthony · Chelsea, MIN5927BEmerson Christopher D · Mount Pleasant, ARN5928BSteinhausen Darrell · Torrington, WYN5929BRegistered aircraftN5932BAbsolute Altitude LLC · Buena Vista, CON5933BManier Byron K · Houston, MON5934BLlk Aviaiton LLC · Hanksville, UTN5936BTorrison Scott D · Chugiak, AKN5938BDocjosh Ltd LLC · Essex, NYN5955BHess Garrett · Fullerton, CAN5957BMiss Mayson LLC · Midland, TXN5961BC&B Aerial Transport Inc · Wilmington, DEN5963BJones Damon · Lafayette, ORN5964BBailey Steven W · Puyallup, WAN5965BMathison John M · Vancouver, WAN5966BLemaster Roxanne · Brookville, OHN5967BKelley William P · Herron, MI
Back to Cessna 182A