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 ('5870208')
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 ('5870208')
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.
N9492VRivera Jaime · San Antonio, TXN9495VSoccer Goals LLC · Christoval, TXN9498VMoonshiner Aviation LLC · Austin, TXN952MKhan Mohsin H · Lodi, CAN953MAGutierrez Francisco J · Laredo, TXN955MATaylor Christopher B · Vacaville, CAN9561MAck & Co LLC · East Helena, MTN956MAAllen William D · Tampa, FLN9601VFoutch Jerry · Merritt Island, FLN9602VPii Fcw Inc · Port Saint Lucie, FLN9603VMacgregor Sinclair D · Oroville, CAN9608MWaryas Robert A · Long Island, VAFirst renewal noticeN960GSStevens Chad M · Huntsville, ALN9638MPinheiro Rodrigo P · Albuquerque, NMN963EAEcho Alpha Aero LLC · Saint Petersburg, FLN9655MJarco Group LLC · Lititz, PAN9656MWashington Aviation Inc · Seattle, WAN9668MHusch Dennis W · Lakeview, ARN9670MUnderwing Aero LLC · Devine, TXN9671MSteed Brian · Winnsboro, SCN9675MDkml Aviation LLC · Celebration, FLN9676MRoberts Eric · College Place, WAN9677MRoberts Eric · College Place, WAN9678MAire Matt Inc · Pequot Lakes, MNN9679MIngalls Brian E · Lancaster, CAN9682MMccormick Borrero Ramon A · Ponce, PRN9683MPourteau Patrick Steven · West Columbia, TXN9684MMayes John · Carson City, NVN9686MMccarty Joseph P · Atlanta, GAN9687MMacaluso Samuel J · Edmond, OKN9689MBrown Jerome D · Simpsonville, SCN9690MKeefler David A · Queen Creek, AZN9691MBrand Keith E · Sale Creek, TNN9693MHiggins Michael · Pasadena, CAN96AWPlanenutz LLC · Deland, FLN9706MDance David C · Idaho Falls, IDN9721MMartin Vincent J · Nevada City, CAN9738MVurlumis George A · Pocono Lake, PAN9741MPeterson Bradley A · Savoy, ILN9742MCastro Laura · Phoenix, AZN9743MAdney William J · Woodville, TXN9744M44 Mike LLC · Highlands Ranch, CON9745MJones Joseph D · Bixby, OKN9751MSchott Milbert F · Richland Center, WIN9754MZiaja Rebecca · Virginia Beach, VAN9760MNeal Alan B · Cherry Valley, CAN9763MWaldren Paden · Garden Valley, CAN9764MSilcott Robert W III · Fairview, OKN9765MMahoney James P · Renton, WAN9767MMcgill James D · Tucson, AZ
Back to Mooney M20C