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 ('2072714')
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 ('2072714')
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.
N3560YTriple J&M Flying LLC · Guymon, OKN3561YDk Futures LLC · Reno, NVN3562UPrairie Aviation Of Hamilton Inc · Corvallis, MTN3563UWest Robert M · Lake Oswego, ORN3563YHegge Luke · Pine City, MNN3564USkylane LLC · Luling, LAN3565YRegistration Pending · Conrad, MTRegistration pendingN3566YTocco Paul J · Crescent City, FLN3568UCsi Aviation LLC · Wilmington, DEN3568YAerial Adventures Demo Inc · Hopewell, VAN3569UHelicopter Of Columbia LLC · Columbia, SCN3569YSage Michael · Opelika, ALN3570UDoyle Neil R · North Pole, AKN3571YIllinois Valley Parachute Club · Carlock, ILN3572UFrappollo Paul M · Berryville, VAN3573UHigginson James E · Bellingham, WAN3573YDesantis Robert George · Tavernier, FLN3574URegistered aircraftN3575YMeyer Robert J · Davis, CAN3576UBinse Gerald R · Yuba City, CAN3576YHmh Consolidated LLC · Lake Placid, FLN3577YClifton Oil & Gas LLC · Millville, DEN3579UIou Aviation LLC · Sheridan, WYN3579YReal Property Services LLC · Bentonville, ARN3580UShiels Patrick Trustee · Flagstaff, AZN3582UMorton Construction Inc · Stillwater, OKN3582YErkens Ronald B · Queen Creek, AZN3583YCollins Carl H · Longview, TXN3584UMagic Valley Aero Club Inc · Twin Falls, IDN3584YHassler John Cameron · East Helena, MTN3585UNieder Brady W · Anchorage, AKN3585YSeemann Brian N · Lake Havasu City, AZN3588UBattles Danny C · Burns Flat, OKN3589YEle Motorsports LLC · Dover, DEN3590YAlexander Macy Nix · Mineral Wells, TXN3592YArcher Donald B · Artesia, NMN3595UBrinkman Eric · Phoenix, AZN3596YHeintz Ludwig C · Covington, LAN3597YCraig & Craig LLC · Merrillville, INN3598UDunn Mark · Visalia, CAN3599YLooker Daniel M · Ferndale, WAN3600URiera Jose Gregorio · Saint Augustine, FLN3602UBritsch Michael J · Anchorage, AKN3607UHastings Flyers LLC · Hastings, NEN3608URegistration Pending · Homer, AKRegistration pendingN3613UN3613u LLC · Lakeland, FLN3614UT Yowonske Enterprises LLC · Rostraver Township, PAN3616UHatch Koay A · Gilbert, AZN3621UStewart Gary T · Friendswood, TXN3622UDegonia Gerald · Plainfield, IL
Back to Cessna 182F