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 engine_model_code IN ('55556')
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 engine_model_code IN ('55556')
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.
N430GCCroley George K Jr · Williamsburg, KYN4313QCraddock Larry E · Gray Court, SCN4317LPrairie Sky Flights Inc · Robinson, ILN43280Miner Jeremiah K · Cambridge, IAN4329RSocia Jared R · Roscommon, MIN43310Nelson Johnny L · Cedar Bluff, ALN43367Miller Marvin R · Finksburg, MDN435BEMiller Gilbert · Richmond, KYN436BEJoos Zupanki · Lexington, KYN43719Maddox James P · Apopka, FLN4373AWhitehead John N · Andersonville, TNN4376NFurr Heath · Cartersville, GAN4383YParadis Robin R · Perham, MEN4387GCastiglia Joseph G · Las Vegas, NVN438ABBryan Robert W · Palatka, FLN44020Macleay James F · Morristown, TNN4404CPenley Brian L · Westfield, INN44092Prepmasters Inc · Boynton Beach, FLN440ABHowell Aviation LLC · Orlando, FLN4413VVanek Jim A · Scappoose, ORN4416GHalas Paul E · Beaver Falls, PAN4419WHaskell Gregory F · Allen, TXN4425LHolmes William B · Phoenix, AZN4434GMars Roy D · Fort Worth, TXN44364Vaughn Vincent G · Paris, KYN44402Dickenson Ronnie · Castlewood, VAN4445GFoust Barry J · Gettysburg, PAN44504Caruso Michael P · Windham, MEN4459BStauffer Bradley E · Dorchester, NEN4462GTarvainen Craig D · Chassell, MIN44680Drone Dennis E · Louisville, TNN448TCSosnowski John C · Richmond, ILN449WVNicoara Samuel · Brooklet, GAN450RKColeman Rex A · Brownwood, TXN451PLawton Walter C · Augusta, GAN453QRLee Ronald Earl Jr · Stokesdale, NCN454APDollar Douglas A · Crawford, MSN454GErtl Gregory A · Yuma, AZN454SSPendergrass Jack R · Orland, CAN4557CBender Larry · Beachwood, NJN455ZDKlingenberg Timothy C · Udall, KSN457PGSumner Thurston B III · Ocracoke, NCN457RSMccraven Craig S · Smyrna, TNN458JSSullivan Jim W · Adolphus, KYN4646LPressley Jeff · Rockingham, NCN46582Wilson Miles N · Mcminnville, TNN466JSOhearn Paul W · Hartford, WIN467JPNeer Slade W · Shinnston, WVN467NCSkyview Powered Parachute Inc · Hutchinson, KSN468XGGoodwin Larry E · Coudersport, PA
Back to Rotax 582SER