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 ('2072618')
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 ('2072618')
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.
N2739XSvoboda Realty Inc · Bucyrus, KSFirst renewal noticeN2742XCallaway Scott T · Soldotna, AKN2747XTaylor Joseph Baker · Anchorage, AKN274TLussier Ian · Owls Head, MEN2753XStorer Charles E · Payette, IDN2755XMcsheehy James B · Fallbrook, CAN2758XAerotechniques LLC · South Kent, CTN2763XThompson Lyndon R · West Fargo, NDN2765XBa Aviation LLC · Anacortes, WAN2768XMullett James L · Mccall, IDN2772XBratten Douglas D · North Pole, AKN2773XLee Ty K · Anchorage, AKN2774XElk Creek Investments LLC · Helena, MTN2776XSmith James A III · Millerton, NYN2777XKruskie Douglas · Petoskey, MIN2780XMontgomery Jeffrey L · Anthem, AZN2781XN2781x LLC · Kingston, GAN2784XGillett Welles III · Horseheads, NYN2786XRegistered aircraftN2798XElsner Kelly John · Menahga, MNN2799XHess James R · Heathsville, VAN2869UDavis Isabelle L · Mason, NHN32DBCarpenter Forrest A · Berthoud, CON3336TBirch Point Ventures LLC · Virginia, MNN333FFBass Thomas M Trustee · Kalispell, MTN3404YCedar Sky Aviation LLC · Wrangell, AKN3405YCampbell Casey J · Sitka, AKN3409YThies Trevor H · Seattle, WAN3411YFinnelly Barry J · Snohomish, WAN3412YSkinner Jason Richard · Templeton, CAN3416YFlying D Farm Inc · Kerhonkson, NYN3417YRice Kenneth J · Moccasin, MTN3422YGumley Andrew J · Wasilla, AKN3426YMachnik Todd J · Old Lyme, CTN3431YMinor Joseph H · Hyannis, NEN3437YLanding Gear Works LLC · Renton, WAN3441YBird Avery L · Wasilla, AKN3443YTurner Nathan D · Nenana, AKN3448YMtdc LLC · Goddard, KSN3449YSteel Rock Aviation LLC · West Jordan, UTN3455YKimmel James W · Fountain Hills, AZN3456YGold Michael Benjamin · Frazier Park, CAN3458YDelahunt David M · Simi Valley, CAN3459YPepper William G · Fayette, MEN3460YLeng Jeffrey E · Buckley, WAN3467YPeninsula Aero Technology Inc · Kenai, AKN3468YSale Reported · Alpine, UTSale reportedN3473CKubecka Donald P · Seminole, TXN3474YHanson Dan B Jr · Lusk, WYN3483YGrimes William H · Seabrook, SC
Back to Cessna 180H