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 ('0630610')
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 ('0630610')
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.
N6111LHoard Ryan · Burley, IDN6113LBonilla Neftali H · Krum, TXN6115LWhite David W · South Fulton, TNFirst renewal noticeN6117LFlight Tech Inc · Arlington, WAN6119L19lima LLC · Elkhart, INN6121LHinds Community College · Raymond, MSN6125LJohnson Gerald A · Sedro Woolley, WAN6129LDodson David W · Granger, INN6132LSale Reported · Charles Town, WVSale reportedN6133LBarnett George W · Salem, INN6136LTheriot Conchita F · Anderson, SCN6139LGdg LLC · Lewes, DEN6141LJohnson Stephen M · Westlake, TXN6145LMichaud Martin R · Monte Vista, CAN6148LYoukey John N · Yuma, AZN6150LRucks Chad W · Okeechobee, FLN6153LMastrangelo John A · Phoenix, AZN6155LPeterson Walter R · Appling, GAN6157LMelcher Robert L Trustee · Muskego, WIN6159LLuciano Nicolas · Harlingen, TXN6161LPlesetz Philip · Manitowoc, WIN6165LGjorvad Steven A · Punta Gorda, FLN6170LCampbell Phillip · Fort Worth, TXN6171LGoode Stephen C · Canton, TXN6172LKantor Dimitry · Essex, MDN6174LHanson Alan L · Manchester, MIN6182LHansen Karl G · Waxahachie, TXN6183LPittsburgh Institute Of Aeronautics · West Mifflin, PAN6189LKnutson Nathan J · Dubuque, IAN6192LTinaglia Aviation LLC · Hot Springs, SDN6210LHanley Kevin M · Littleton, CON6219LBradley Jason · Fort Mohave, AZN6221LBorge Michael J · Chandler, AZN6224LJohnson Lucas · Pleasant Lake, MIN6227LAbraham Joe C · Bristow, OKFirst renewal noticeN6237LHolman Darryl J · Redmond, WAN6238LLindgren John R · Monroe, WAN6240LCustard Tom W · Valencia, CAN6251LDavis William Ray · Cypress, TXN6252LHaynes Larry C · Troutman, NCN6256LGuy Jon C · Margate, FLN6257LBearden Robert · Chatsworth, GAN6258LGreene Carl E · Hayden, IDN6259LRosche Henry III · Loveland, OHN653Jordan Ronald D · Little Rock, ARN666YZDon Jones Inc · Orange Beach, ALN748WHHuete Charles W · Carriere, MSN76HBSinger Michael · Mission Viejo, CAN797MPJezierski Michael David · Westfield, INN917BRWhitener Gary C · Fredericktown, MO
Back to American AA-1