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 ('2071826')
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 ('2071826')
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.
N50JXDls Holdings Inc · Arlington, TXN50XFHdw Florida Helicopters Inc · Pompano Beach, FLN510SUOhio State University · Columbus, OHN5202QRosso Matthew J · Mancos, CON5203QMatteis Vincent M · Lyndonville, VTN5204QWarren County Career Center · Lebanon, OHN5208QEmerick Benjamin F · Foster, RIN5209QTulsa Technology Center School District No 18 · Tulsa, OKN520JCSisson Christopher S · Sarah, MSN5213QMedia Stew LLC · Carson City, NVN5214QMann Roland F · Murrayville, GAN5217QGoode Stephen C · Canton, TXN5219QVital Aviation LLC · Monterey, CAN5223QThealphamart LLC · Saint Petersburg, FLN5224QRiibe Gary J · Herman, NEN5225QMiller Kevin L · Arlington, WAN5227QFoster Kathleen E · Long Beach, CAN522KSkyhigh Aviation Investments Inc · Daytona Beach, FLN5235QPoules Alexander · Hope Valley, RIN5236QPeters Terry M · Okeechobee, FLN5237QKretschmer Bryan · Hawthorne, NJN5238QMolek Jon · Warren, OHN5239QWayland Johnny R · Stephenville, TXN5240QRamesh Manohari D · Liberty Township, OHN5242QShimata Kenneth S · Honolulu, HIN5247QCavu Pilot LLC · Powell, TNN5248QSmith Gary A · Ericson, NEN5249QLarson Loren R · Omro, WIN5250QLegan Matthew · Franklin, INN5255FHirsch Jeffrey D · Lutherville, MDN5259QFrantz David L · Murfreesboro, TNN5265QCohan John K · Marina, CAN5267QGibson Aviation Services LLC · Hudson, WIN5270QPitman Mark T · Princeton, MNN5271QBridges Paul J · Denton, TXN5275QSkyfarmer LLC · Culleoka, TNN5276QCarter Nolon D · Kirksville, MON5278QRegistration Pending · Madison, MSRegistration pending, canceledN5281QHhd Aviation LLC · Hamilton, OHN5285QBartell Kevin W · Abbottstown, PAN5286QPasterski Mark F · Chicago, ILN5287QRice James L · Mckinney, TXN5288QErnie Hall Aviation Museum Inc · Warren, OHN5289QNielson Douglas W · East Troy, WIN5290QSaso Jan D · Hughson, CAN5291QQuinn Robert J · Kelleys Island, OHN5293QRoberts Jeffrey E · Wheeling, WVN5296QSun Baron · Arcadia, CAN5297QFalmouth Aviation LLC · North Falmouth, MAN5298QKirsch Richard D · Lisbon, ND
Back to Cessna 150L