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 ('2072732')
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 ('2072732')
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.
N95841Para David B Trustee · Prescott, AZN95848Makowski Maciej J · Nipomo, CAN95857A & M Airplane LLC · Grover Hill, OHN95858Tucker Thomas O Jr · Austin, TXN95860Cumberland Air LLC · Stuart, VAN95863Shields Stephen T · Holly Springs, NCN95865Registered aircraftN95868Descco Design & Construction Inc · Fleetwood, PAN95879P3 Aviation LLC · Austin, TXN95897Fisher Thomas F · Olalla, WAN95912Yound Anthony J · Washington Island, WIN95915Isaly Robert P · Lighthouse Point, FLN95928Brooker Robert A · Sebring, FLN95935Platt James C · Grants Pass, ORN95937Smith Doug S · Bowling Green, OHN95945Storm Theodore W · Tampa, FLN95963Wyzykowski Joseph P · Wasilla, AKN95967Hadley Nicholas J · Guilford, CTN95981Lloyd Charles W · Nevada, IAN95GRSim International Inc · Fort Mill, SCN95GSStephen George A · Anna Maria, FLN95MBNobbe Leon W · Greensburg, INN961ERCoyote Air LLC · Hermiston, ORN9624EA & I Aviator Investments LLC · La Habra, CAN96393Graham Eric H · Johnson City, TXN96403Skylens LLC · Hammond, LAN96410Penny John C Jr · Sterling, CON96411Zz Top Rentals Inc · Missoula, MTN96416Wolstenholme Ralph E · Westfield, PAN96418Twin City Cloud 7 Inc · Eden Prairie, MNN96419Thompson Steven · Rockwall, TXN96455Haeussler Arne · Chandler, AZN96462Skylens LLC · Hammond, LAN96474Skylane 4 LLC · Leesburg, FLN96475Gregg Flying Service Inc · Durango, CON96476After Global Holdings Corp · Wichita, KSN96480Mfkc182 LLC · Lantana, TXN96490Schabacker Charles W · Jerome, IDN96491Registered aircraftN964TMByrd Properties LLC · Olathe, KSN96500Granado Jose Jr · Chandler, AZN96505Price James Wilson · Big Stone Gap, VAN96509Aircraft Equities Inc · Wilmington, DEN96510T34b LLC · Seattle, WAN96515Harrill David H · Charlotte, NCN96516Quanz Bernard A · Wayland, NYN96524Kddt LLC · Meeker, CON96531Goldeneye Air LLC · Orange, CAN96551Brentco Aerial Patrol Inc · Canton, OHN96568Herman Quiroga · Phoenix, AZ
Back to Cessna 182Q