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 ('1151425')
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 ('1151425')
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.
N25JFaria Manuel Steven Trustee · Tipton, CAN25QYCuller Richard E · Winston Salem, NCN25RDHamilton Robert L · Vashon, WAN25RHPoseidon Transport Inc · Watertown, NYN262PMBig Bend Community College · Moses Lake, WAN2658BBrowning Frank W · Port Orange, FLN2670MPhelan Construction LLC · North Andover, MAN2693KKelman Naomi · Nashville, TNN26PVWoods H Ross · El Dorado, ARN26RTInternational Air Services Inc Trustee · Carson City, NVN26URDartswift Inc · Philadelphia, PAN270KFirst Gear Inc · Fort Wayne, INN2730RRp Aviation Inc · Alliance, OHN273PSBlack James F · Sister Bay, WIN278CRRittgers Timothy · Lapeer, MIN282RTenere Ventures LLC · Wilmington, DEN2838WFreebird LLC · Leawood, KSN2854PHakari Wesley Jon · Sioux Falls, SDN285HGeorge Gary D · Humble, TXN2863WWarrick Motors LLC · Newton, IAN2998MM T Aviation LLC · Grove, OKN2999MLopez Eve · Santa Monica, CAN2999NGarcia Michael R · Marshall, VAN299BGHarrison Rv Inc · Jefferson, IAN299CLNealy Steven · Eaton, CON29EALorimor Thomas T · Sidney, IAN2FKAshwath Nagaraj · Los Altos Hills, CAN2HJLittle Eagle Valley LLC · Dover, DEN2LHStotlar Richard L · Tucson, AZN2UGBaker Gregory L · Hilton Head Island, SCN300RSLane Tyrone · El Dorado Hills, CAN300SAWhalen Sean B · Naples, FLN300TTDg Aero LLC · Little Rock, ARN3012HBonanza Two USA Inc Trustee · Wilmington, DEN3024QJones Sean D · Adams, TNN303KCCurry Kenneth R · Cookeville, TNN3041KDodson International Parts Inc · Rantoul, KSFirst renewal noticeN3042NRunway Aircraft LLC · Sugar Land, TXN3049APresidential Aviation LLC · Bakersfield, CAN3052XJc Flight Inc · Wilmington, DEN3053WVictor Echo LLC · Knoxville, TNN3056KOwens Grace P · Brunswick, GAN3056WRoss John C · Susquehanna, PAN305BCProp & Wing Aviation Inc · Humble, TXN3076TPoint Two Six Avation LLC · Scottsdale, AZN3077HAir Frame Worx LLC · Wilmington, DEN3077KBaldus Scott William · Waxhaw, NCN3077U3077u LLC · Dallas, TXN3078HHorn H Fred · Cedar Rapids, IAN30797Johnson Alan L · Pikeville, KY
Back to Beech F33A