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 ('2072622')
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 ('2072622')
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.
N64AJN64aj LLC · Winterset, IAN669CBMckinney Eric · Hamersville, OHN6942VWaters Tracy J · Pittsboro, NCN6BKAerovana LLC · Caldwell, IDN6SFWeatherbe Mark B · Lincoln, MEN6WHWoldow Fredric A · Morton, ILN7067BMcdonald John M · Lyons Falls, NYFirst renewal noticeN707WCAcp Aviation LLC · Oakdale, LAN7084FState Of Wisconsin · Madison, WIN711JMCarro Del Cielo LLC · Santa Paula, CAN743KSBarrett Buford L · Bristol, VAN7458FTorode John Q · Hunts Point, WAN74CGTrainor Thomas P · Fairbanks, AKN7510KFreienmuth Karl S · Shorewood, MNN751CFSebec Aviation Services LLC · Abbot, MEN7520KGraber Raymond B II · Carson City, NVN7521K5b 7b Aero LLC · Sandpoint, IDN7522KDewitt David B · Santa Rosa, CAN7527KMark D Jones · Kremmling, CON7529KBarak David T · Mountain Home, IDN7530KMcmanigle Jeffrey M · Osakis, MNN7551KBoone Richard Kevin · Wichita Falls, TXN7553KRichardson Richard E II · Windham, MEN7560KAlbert Bryan Wayne · Palmer, AKN7582KErb Jason E · Barron, WIN7583KBaker Mark L · Murfreesboro, TNN7612KDeblack Richard B · Crosslake, MNN7616KHarrison William Thomas · West Richland, WAFirst renewal noticeN7642KJobe Alexander Joseph · Asotin, WAN7654KLuginbuel Stacy W · Prairie Grove, ARN7662KBredthauer Glen · Hastings, NEN7668KAviation Enterprises Aircraft Sales LLC · Springfield, MON7674KToms Robert G · Holly, MIN7680KStripe Joseph R · Olympia, WAN7681KNewberry Robert L · Lakeland, FLN7684KWard Keven R · Juneau, AKN76LGHeimbach Ann M · Duluth, MNN7702KRose Hugh S · Fairbanks, AKN7715KDutch Air LLC · Kalispell, MTN7724KGardner Thomas W · Lincoln, MEN7731KMorrison Richard Trustee · Anchorage, AKN7749KParshall Stephen T · Olympia, WAN7751KKyer Barry P · Honey Grove, TXN775PSCrop Jet Aviation LLC · Gooding, IDN7761KGoldmark Peter J · Olympia, WAN7770KAir Craft LLC · Sheridan, WYN7779KSeventy Six Juliet LLC · Oakland, CAN7780KRegistered aircraftN7782KHaughee Jared · Warsaw, INN7792KStoor Danny W · Fountain Hills, AZ
Back to Cessna 180J