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 ('0630710')
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 ('0630710')
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.
N9240LRollins Loftis J · Lakeland, FLN9241LMurray Bradley R · Rockingham, NCN9244LLanza Philip R Sr · Modesto, CAN9246LBeery Bruce M · Lakeland, FLN9250LBullitt Richard T · Humble, TXN9253LMaj Holdings LLC · Norfolk, VAN9254LDeyager John E · Chapel Hill, TNN9255LBegley Edward R · Glasgow, KYN9259LWright Brandon · Cave City, KYN9261LDuran Nick R · Cleburne, TXN9275LEn Productions LLC · Grand Rapids, MIN9276LCueva Arturo A · Los Angeles, CAN9277LMoseley Warren C · Arlington, TXN9280LFennig Richard L · Virginia Beach, VAN9284LWilkins Perry · Chesapeake, VAN9289LMainland Thomas L · Kansasville, WIN9296LTrites Henry E · Granville, OHN9299LKing Angela · Raleigh, NCN9300LWesley Robert J · Chuckey, TNN9301LColton Paul F · Orlando, FLN9302LBffe Inc · Homestead, FLN9303LMathison John M · Fernley, NVN9304LBraithwaite Lester T · Camino, CAN9305LSutphin Harold W · Saint Cloud, FLN9306LRobinson Mark V · Vacaville, CAN9308LRegistration Pending · Horn Lake, MSRegistration pendingN9310LGavitte Peter F · Napa, CAN9313LKlutz Stoner W · Bristol, TNN9314LEastern Stearman Inc Trustee · Leesburg, VAN9315LWilliams Matt D · Xenia, OHN9320LColton Casey Daniel · Lutz, FLN9325LMartin David Gary · Huntington, ARN9328LCastro Tony · Duluth, GAN9329LHills Holding · Newark, DEN9331LMalone Robert L · Cleveland, TNN9332LPalone Carmen · Rices Landing, PAN9334LMedic Choppers LLC · Springdale, ARN9335LGulfstream Aerospace Corp · Savannah, GAN9339LLumbra Valerie A · Lehigh Acres, FLN9342LSeaton Robert D · Seguin, TXN9343LC&L Aviation Ltd · Maysville, KYN9349LKearney Isabelle · Oklahoma City, OKN9351LPiciullo Lenny R · Folsom, CAN9354LElliott Brevyn · Marinette, WIN9356LCallaway Jonathan L · Van Alstyne, TXN9360LSwanson Steven V · Saint Marys, GAN9361LWillis Daniel A · Clarksville, TNN9363LAmzallag Gerard Reuben · Oxnard, CAN9365LHartzog Christopher G · Greenwood, SCN9367LHummel Mark I · Lakewood, WA
Back to American AA-1A