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.
N6350BLefeve Douglas H · Cedar Park, TXN6354BSgc Soaring Foundation · Bellevue, WAN6355BRich Lucas Aircraft Sales LLC · Lincoln Park, NJN6356BStaudacher Nicholas R · Midland, MIN6362BSimplot Don J · Boise, IDFirst renewal noticeN6365BKnopp Steven L · Camano Island, WAN6367BSmart John H · Chugiak, AKN6369BWilliams James R Trustee · Reno, NVN6373BLee Kevin · Beulah, NDN6375BBarrientos Jeri D · Collinsville, OKN6376BMisty Blues Skydiving LLC · Highland, MIN6379BPittman William Greg · Anchorage, AKN6383BLewark Larry D · Frisco, CON6390BPalmer Bryce P · Chugiak, AKN6392BHubatka Wilferd · Creston, IAFirst renewal noticeN6393BLebard Racquele J · Sparks, NVN6395BMb Laster Aviation LLC · Eagle, CON6396BGeezer Guys LLC · Eloy, AZN65006Delvalle Enterprises Inc · Sandpoint, IDN659SDCall David A · Carson City, NVN711GWZwar Jeffrey · Methow, WAN711TGRegistration Pending · Lakeville, MNRegistration pendingN71MWWalker Michael E · Lewistown, MTN727CMoore Kelly M · Moscow, IDN73CQHillesheim Steven T · Grass Valley, CAN73GJSkydive Greene County Inc · Xenia, OHN73TPTop Aircraft Leasing LLC · Wilmington, DEN751DRNew Daniel A · Deming, WAN766VNCagle Jonathan D · Mobile, ALN767RSRegistered aircraftN7842CWemhoff Jason L · Coeur D Alene, IDN7RWNelson Jeffrey S · Darby, MTN81LTDob Air LLC · Baiting Hollow, NYN82YMiller Charles G · Anchorage, AKN84FFKoorenny Brian G · Clarkston, WAN8539ZRiggs Randy G · Creede, CON8645TLaplante Bruce E · Vilonia, ARN876SPb Limited LLC · Kalispell, MTN885QMMoore Timothy L · Wendell, IDN88MALowry Michael L · Chesterton, INN891SPSkydive Pennsylvania · Mercer, PAN898TMKingsley Kaland W · Miller, MON911JTSchaefer Kent M · Anacortes, WAN911MDAirplex Aircraft LLC · Springfield, MON914MDCrum Brian B · Warrensburg, MON915XKSk Aircraft LLC · Anchorage, AKN9175Herbert Aviation LLC · Spring City, UTN922DUp Jump Enterprises LLC · Morristown, TNN926CSHardee Philip S · Florence, SCN93MMChristenson Robert E · Anacortes, WA
Back to Cessna 182A