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 ('2072434')
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 ('2072434')
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.
N738VBBrafa Frank T · Leesville, LAN738VCMarlin Walter E II · Locust Grove, GAN738VJCommand-Aire LLC · Seattle, WAN738VLBasler Leon E · Sainte Genevieve, MON738VRWoodward Tyler James · Norman, OKN738VUFive Rivers Flight Training LLC · Livermore, CAN738VVPureflight Aviation Training LLC · Newberg, ORN738VYRpm Aero LLC · Lincolnwood, ILN738WCBrb Grand-Air LLC · Indiantown, FLN738WEBray Aviation LLC · Calera, OKN738WGZlock David · Lakeville, MNN738WJSpann Leonard D · Little Rock, ARN738WLBrenair Inc · Mcalester, OKN738WMMayers Trevor D · Miami, FLN738WNSkywarrior Flight Training LLC · Pensacola, FLN738WRRoberts Dwight C · Seminole, OKN738WYIsland Aircraft LLC · Anchorage, AKFirst renewal noticeN738WZPitman Steven M · Lyman, SCN738XAHyldburg Aviation · Plymouth, MAN738XDMls Aviation LLC · Yorba Linda, CAN738XFTynan Flyers LLC · Tynan, TXN738XGWest Central Georgia Flying Club · Thomaston, GAN738XKBailey James D Trustee · Marana, AZN738XLM&A Aviation LLC · Vine Grove, KYN738YBMark Stoughton · Salley, SCN738YCN738yc LLC · Fresno, CAN738YHWebster Deryl Thomas · Angola, INN738YJOzarka College · Melbourne, ARN738YLCarter Flygare Inc · Sacramento, CAN738YPFuselier Byron · Rayne, LAN738YRYankee Romeo LLC · Wilmington, DEN738YSHood Jerry R · Double Springs, ALN738YTB2fh Ltd · Allentown, NJN738YWLeemon Kenneth V · Scottsdale, AZN738YXHogan Patrick B · Simpsonville, SCN738YZHotton Ralph A · Canton, MIN738ZASale Reported · Ogden, UTSale reportedN738ZCN738zc LLC · Tallahassee, FLN738ZDChristiansen Aviation LLC · Wilmington, DEN738ZELagow Virgil M Ll · Muskogee, OKN738ZFMann Don R · Mount Vernon, OHN738ZGPopescu Daniel · Nokesville, VAN738ZHRegistration Pending · La Porte, TXRegistration pendingN738ZLGoyal Vishal · Walnut Creek, CAN738ZMAero Lease And Trading LLC · Miami, FLN738ZNRobins David B · Lander, WYN738ZQRieman Joel · Lompoc, CAN738ZRFicus Point Aviation Corporation Inc · Middletown, DEN738ZTSp Airparts LLC · Moscow, IDN738ZUSkydance Aviation LLC · Chesapeake, VA
Back to Cessna 172N