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 ('0690009', '060009Y', '05622D3')
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 ('0690009', '060009Y', '05622D3')
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.
N312PWPickhardt David R · Lindenhurst, ILN312RDGranville David M · Newport Beach, CAN315KJ-Kru Transport LLC · Twin Lake, MIN316AMOlive Jay · Madison, ALN319EDAyers David D · Salem, ORN319RVRatliff Mark R · Del City, OKN31EHHalyburton Elliot T · Three Lakes, WIN321SBN321sb LLC · Sherwood, ORN321UTEaglet Aircraft LLC · Wilmington, DEN322WDJohnson Kyle Ryan · Carthage, TXN323ECJ M Construction & Associates Inc · Orlando, FLN324VASeaman Donald P · Phoenix, AZN325NKOwen Mark A · Apple Valley, MNN326SKTiger 846 LLC · Wilmington, DEN3282FNussbaum Joel H · Ocala, FLN328KLRegistered aircraftN32TTSkyhawk Flight LLC · Toledo, WAN32YESpirits Of Aviation Flying Club LLC · O Fallon, MON3312LLawrence David W · Newcastle, MEFirst renewal noticeN331PSPanchesine John P · Millville, NJN331PTAustin Dean B · Houston, TXN331RVCareer Path Aviation LLC · Portland, ORN337JGRegistered aircraftN339RPKennedy Sam Delk Jr · Columbia, TNN33EVAcorn Aviation LLC · Rose Valley, PAN33LSNeedham George T · Seattle, WAN33SNSmith Dennis L · Carthage, NCN345JKPerrien Aviation LLC · Grosse Pointe Wood, MIN345LBLavoy Leonard C · Bradenton, FLN351DHCarlson Blake A · Crookston, MNN351RVElzinga Joseph B · Caledonia, MIN353MAKloss David C · Andover, MAN355EJWings Of The Sonoran LLC · Goodyear, AZN361BGRegistered aircraftN364SBHuber Jerrold L · Kewanee, ILN3671ABurke Stephen N · Spotsylvania, VAN367ABTraylor Robert C · Tucson, AZN369JBKivell Bret J · Aurora, IAN375RKGering Bruce J · Sioux Falls, SDN375RVGores Joseph N · Riley, MIN377DGMeyer Erich D · Lewisville, TXN37BNSmith Robert Z · Saint Petersburg, FLN37JPRamsey Rickie D · Terre Haute, INN390MVMax Power Aircraft LLC · Kenosha, WIN393JRCompass Aviation Inc · Shelby, NCN3942ARose Michael · Buckingham, PAN397JCWyble Bryan · Bridge City, TXN399ADOgden Aubrey D · Georgetown, TXN399FPCrawford David B · Warren, OHN39JHDance Carlton S · Center, TX
Back to Vans RV-12