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 ('7150061')
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 ('7150061')
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.
N506MBRomig William James Trustee · Virginia Beach, VAN512JSSutton James · Clinton, NCN535PWBentley Management Group LLC · Redondo Beach, CAN591RSLalumandier Henry Carroll Jr · Baton Rouge, LAN603AEPinch Aviation LLC · Monticello, INN60FAHighlights Best Inc · Middletown, DEN610TCNordic Aviation LLC · Mattapoisett, MAN636MRGarrison Rodney · Atlanta, TXN657SHBonanza Of Delaware Inc · Wilmington, DEN659EAntinnes Jennie · Hattiesburg, MSN661CADallas T51 LLC · Arlington, TXN673E4m Aircraft Services LLC · Santa Rosa Beach, FLN6980BBlack Bravo LLC · Newark, DEN7102RDouble D Aviation LLC · Sarasota, FLN7117JTeek Air LLC · Camden, DEN7121VHanson Bryan · Fort Pierre, SDN7133YSanbuck Inc · Troy, ALN7156VEastern Aviation Fuels Inc · New Bern, NCN715MKBig Blue Aviation LLC · Hayward, CAN715MWBull Mountain LLC · Cisco, TXN718TTMulheron Kevin R · Fredericksburg, VAN7255TJmfr Aviation LLC · Dallas, TXN7258NEuroaviation Inc Trustee · KematenN72PLGeneral Rental LLC · Deerwood, MNN736GParadise Aviation LLC · Scottsdale, AZN754HCLincoln Road Real Estate LLC · West Union, IAN75TLGardner John · New Hudson, MIN771CGDtj Properties LLC · Miramar Beach, FLN77LJEastern Point Inc · Dover, DEN789MPMeair LLC · Tewksbury, MAN7WZN7 Whiskey Zulu LLC · Cincinnati, OHN802PNCutnrun Sport Fishing LLC · Port Jeff Sta, NYFirst renewal noticeN812APMark III Construction Inc · Sacramento, CAN83DZKorndorf Aviation LLC · Sugarloaf, FLN846CSRamsey Phil A · Mountain Brk, ALN888TNNightlinger Enterprises LLC · Midland, TXN88WXSeegert James C · Chico, CAN900TDVenucot Management LLC · Houston, TXN925MRElectra Boone Aviation LLC · Dallas, TXN949DALongfellow An LLC · Dallas, TXN95PRRogers Mark E · Livingston, TXN95THT3 LLC · Fort Lauderdale, FLN9663Cfl Partners Inc · Orlando, FLN966SBBenites Frank M · Phoenix, AZN966SKCodorniz Aviation LLC · Houston, TXN975WAvion LLC · Athens, GAN991MAKodar LLC · Basking Ridge, NJ
Back to Raytheon G36