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 ('2072734')
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 ('2072734')
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.
N737LQAmbrosio Michael · Cypress, TXN737LTMcgehee Robert · Baton Rouge, LAN737NDCochise College · Douglas, AZN737PFN737jj Aviation Inc · Punxsutawney, PAN737TSSeven Tango Sierra LLC · Yuma, AZN737VUBlog Thomas M · Santa Fe, NMN737XXEgan Walter G Jr · Port Orange, FLN737YKKaher Ryan G · Menlo Park, CAN737ZZRandick George A · Birch Run, MIN7380RLewis University · Romeoville, ILN7383XMcdonald Michael R · Sunnyvale, CAN7389TWeaver James C · Dunwoody, GAN738AEAvco Patrol LLC · Lyndon, KSN738AXBlevins Donald Paul · Forest, VAN738CKPhillips E Rolland · Concord, NCN738EELipira Robert S · Melbourne, FLN738EQElliott Darren · Vega, TXN738LPPython Financial LLC · Kalispell, MTN738PGBas Part Sales LLC · Greeley, CON738PRS D Sky Tales Inc · Chuckey, TNN738QKSik Kelly · Murrieta, CAN738TFFly Vector LLC · Spring Hill, FLN738UUCiuccio Louis V · Old Forge, PAN738WKMallette Christopher Lee · Saint Rose, LAN738ZBDyberg Mike · Mount Vernon, WAN7395XBrl Air LLC · Onsted, MIN739BSDooley James M Jr · Ashland, VAN739CBRoberts Bryce · Bedford, WYN739CLTower Ty LLC · Calhan, CON739DMShorten Craig · Atlanta, MON739JGLfw Investments LLC · Hillsborough, NCN739VFGriffin Michael J Trustee · Chesterfield, MON739ZRJw Horton Aviation LLC · Rogers, ARN744HRStefan William C · Lockwood, MON747ABFlyco Inc · Colorado Springs, CON747BFMjm Enterprise Holdings LLC · Drexel, MON747PPCp Aviation Inc · Santa Paula, CAN7557TArizona Flyers Club Inc · Tucson, AZN7557XWright Aero Inc · Saint Cloud, MNN755MCCisneros Joe M · Nashville, TNN7561XNri Flying Club Inc · Walnut Creek, CAN7565XDonaldson Bros Flying Circus LLC · Spencer, IAN7568TSale Reported · Phoenix, AZSale reportedN7568YAviation Associates LLC · Oxford, MDN756ARTehama Angus Ranch Inc · Gerber, CAN756BCBuchanan Bryan DBA · Gig Harbor, WAN756EBTak Holdings LLC · Pleasant View, TNN756EFTim Daniels Inc · Labelle, FLN756EMPacific Aircraft Management LLC · Tacoma, WAN756EUFisher Air LLC · Cardington, OH
Back to Cessna R182