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.
N9332XM & D Blomquist LLC · Central Valley, UTN9333X1927 Enterprises LLC · Overland Park, KSN9337XValentine Richard E · Holt, FLN9339XSedona Aviation LLC · Sedona, AZN9343XYoung Charles T · Los Banos, CAN9345XBordner Christopher P · Santa Cruz, CAN9348XWhittemore Kenneth P Jr · Fredericksburg, VAN9349XDicarlo Jason M · Covington, LAN9352XLinhart Charles W · Dayton, WYN9356XGibson Kenneth W · Washougal, WAN9360XReist Glenn A · Moulton, ALN9364XHatfield Steven P Trustee · Clearwater, KSN9365XHallows Hc Holdings LLC · Salina, UTN9367XLivingston Robin L · Vail, AZN9368XS & D Aviation LLC · Pamplico, SCN9369XPletcher Marvin D · Yuma, CON9371XAdventure Aircraft And Equipment LLC · Chelan, WAN9372XSleeping Giant Flying Club Inc · Helena, MTN9375XRubber Chicken Airlines LLC · Kalispell, MTN9379XFoster Hartford L · Whitefield, MEN9380XJacobi Gregory A · Alex, OKN9381XLazy Eight Flying Club LLC · New Richmond, WIN9385XPipkorn Alan J · Phillips, WIN9387XKillam Rodney A · Carlinville, ILN9389XBeckelic Michael E · Acworth, GAN9391XGravenstede Nelson F · Newton, NJN9394XBlue Sky Flyers Inc · Punta Gorda, FLN9398XRegistration Pending · Chillicothe, OHRegistration pendingN9399XStorm Flying Service LLC · David City, NEN997TXPeso Consulting LLC · Lexington, TX
Back to Cessna 182E