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 ('1380144')
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 ('1380144')
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.
N57414Latta Russell R Trustee · Atwater, CAN575Stearman 575 LLC · Wilmington, DEN5815VDebs Raymond E · Boise, IDN5819VHoefly Christopher S · Belleview, FLN5820VTefel Joshua · Bayport, NYN59184Marken Jeffrey R · Baker, FLN59293Porter Andrew W · East Liverpool, OHN59472Bertram Jon · Genoa, ILN59695Hertel William R · Granbury, TXN6004MRare Aircraft Ltd · Faribault, MNN60390Kansas Radial LLC · Benton, KSN60955International Air Services Inc Trustee · Carson City, NVN61116Coughlin Edward L · Cazenovia, NYN61PJones Kermit Lafayette III · Jasper, ALN62416Bolton Donald S · Hernando, MSN6241DMartin Stephen · Pampa, TXN62426Phantom Eagle LLC · Hot Springs, VAFirst renewal noticeN63268Hoffrage Michael B · Fresno, CAN63360Rawson John A · Orange, CAN63707Ayers Aviation LLC · Gainesville, TXN63712Longuski Francis J · Vassar, MIN64037Hawks Zero Q3 LLC · Sonoma, CAN64387Bossola Raymond L · Suffolk, VAN64434Niemyjski Justin S · Franksville, WIN64502Varpagel Richard H · Elkhorn, WIN64558Stearman Adventures LLC · Ponder, TXN64587Ostrich James T · Ocala, FLN64648Leahy David J · Delaware, OHN64650Fitzgerald Kenneth J · Spokane Valley, WAN64890Michael Anna B · Lexington, NCN64965De Jong Thomas · Buckeye, AZN64WLutes Ralph E · Shipshewana, INN65004Tisler Mark R · Bemidji, MNN65020Qualitair LLC · MichelstadtN65228Scarbrough Daniel R · Palestine, TXN65263Third Strike Wing Walking US Corp · Masham QuebecNon-citizen corporation, flight hours not reportedN65292Davenport Ross K · Raleigh, NCN65293Independent Dusting Svc Inc · El Campo, TXN65368Air Cav Helicopters LLC · Wilmington, DEN65369Burrill Michael E Jr · Medford, ORN65467Fletcher Flying Service 419 LLC · Labelle, FLN65543Murphy Scott M · Lebanon, NJN65544Vogel Mark E · Spokane, WAN65565Aerospace Trust Management LLC Trustee · Wilmington, DEN65666American Airpower Heritage Flying Mu · Dallas, TXN65669Aas LLC · Ovid, MIN65693Burroughs David G · El Paso, ILN65696Yates Christopher R · Henderson, NVN65993Mincer Robert B · Canandaigua, NYN65996Leavitt Craig · Spicewood, TX
Back to Boeing B75N1