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 ('0631410', '0630711')
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 ('0631410', '0630711')
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.
N5865LMontez Santiago S · Mesa, AZN5866LRickman Loy D · Sunrise Beach, MON5867LLytle David C · Portage, WIN5868LEngineering Forensics Inc · Glen Burnie, MDN5871LSleeper James A · Middleburg, FLN5872LMai David A · Chattanooga, TNN5877LFlyboys Aviation LLC · Sioux City, IAN5878LGomez Blanco Rafael · Lakewood, CAN5882LBreazeale Peter · Orangeburg, SCN5883LOst Kenneth Alan · Langhorne, PAN5889L100 Rads Corporation · Omaha, NEN5890LSturgeon Kenneth V · Winter Garden, FLN5891LAlldridge Thomas H · Cochranville, PAN5893LHegwood Jonathan E · Petal, MSN5894LTrueblood Terry L · Effingham, ILN5895LWatkins Marion D · Mcdonough, GAN5897LCulver Christopher J · Rockmart, GAN5898LLamer Benjamin W · Ada, MIN6010LBergstrom Robert L · Amelia, VAN6011LBiondich Amy Sue · Rubicon, WIN6012LCloudkicker Lc · Sioux Falls, SDN6013LCraven Jeremy A · Winter Garden, FLN6019LSparrow Hawk Aviation LLC · Moraine, OHN6020LJenkins David B · Hemet, CAN6023LLysogorski Edward P · Bridgeport, MIN6026LDolan Kathleen M · Sunnyside, WAN6033LEberhardy Mark J · Greenville, WIN6034LSunflower Sport Aviation LLC · Fort Leavenworth, KSFirst renewal noticeN6037LRaphael Craigen Michael · Point, TXN6039LMilovich Edwin G · Lebanon, PAN6040LPopio John A · Marysville, OHN6041LAirspeed Marketing LLC · Phoenix, AZN6043LVans Aero LLC · Newburgh, INN6044LMercado Juan T II · Angier, NCN6045LStoll Russell J · Amherst, NYN6047LFisher Sandra · Discovery Bay, CAN6050LPerry David · Onancock, VAN6051LMiller Lyndon · Georgetown, TXN6052LHoward William R · Newnan, GAN6058LMccune William D · Tehachapi, CAN6062LFoo Flyers LLC · Charlotte, NCN6064LBohannon Jessica · Tomball, TXN6070LPloski Greg · Prospect, CTFirst renewal noticeN6072LLawrence Blake C · Monument, ORN6073LKottke Benjamin P · Central Point, ORN6078LHott Jack R · Springboro, OHN6080LBowers Scott · Soddy Daisy, TNN6085LLevy Stanley · Arcadia, CAN6087LSundsmo Sheldon L · Adams, WIN6088LCollins Harold H · North Las Vegas, NV
Back to American AA-5