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 ('55558')
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 ('55558')
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.
N440LSGates Larry J · Rainier, ORFirst renewal noticeN46434Radford Rhett L · Groveland, FLN4848RShae Steven D · Rochester, MNN48902Carlson Kenneth M · Sault Sainte Marie, MIN5058ZWeatherly Lloyd W · Wittmann, AZN5082MLund Wayne E · Deridder, LAN5116NLambertus John · Terre Haute, INN5121YDuncan John S · Maple, NCN5157TMerrill Chester R · Benson, AZN518LDRech Daniel L · Rock Port, MON521PQTango Logistics Inc · Cheyenne, WYN533KFSands Steve G · Monmouth, ORN533MGSmith Mikel G · Tonasket, WAN5369XRosas Jose L · Baker City, ORN536VQMaisonet Morales Ariel Ivan · Gurabo, PRN55059Case Richard C · Cypress, TXN556LMWells Eric L · Wasilla, AKN5613NSimon Jerry · Girard, KSN5632EBiser R Scott · Montgomery, OHN563HHPortie Keith A · Sulphur, LAN5660VSoder Marcia A · Brownsburg, INN56835Greenfield Daryl R · Elkton, KYN56912Haxby Leonard · Butte, MTN582AHSeymour William M · Southside, ALN582DFBurril Ben D · Locust, NCFirst renewal noticeN582RXGarrett Dennis D · Eudora, KSN582STStallings Arthur J · Mckinney, TXN582XTAirborne Over Cody LLC · Cody, WYN594ZSMarkota Michael T · Saugerties, NYN598RPayne James I · Benton City, WAN60464Oliveras Pedro A · Clay Center, KSN60661Registration Pending · Reeds, MORegistration pendingN608DDDana Richard D · Paradise Valley, AZN608DJJohnson Daniel R · Meridian, MSN611PWJohnson Dennis B Jr · Poland, NYN6146ZHaines Frederick H · Presque Isle, MEN6167ZRoark Wayne · Wise, VAN6173XGreen Michael E · Sandy, UTN6243XDaniels Michael D · Owasso, OKN648LHHermen Larry L · Beecher, ILN6513VMollineaux Oscar D · Absecon, NJN65406Kowitz Brenda L · Hutchinson, KSN65796Hunt William H Jr · Peotone, ILN65SSCaptain Drakes Family Aerial Adventures LLC · Cave Junction, ORN65XLSlezewski Kevin T · Brussels, WIN666JLKaiser Lawrence E · Broadalbin, NYN68GDHarris French E · Forest City, MON690JGKling Gene · Lemmon, SDN694FQKitfox LLC · Chesaning, MIN70309Boster Joe D · Van Buren, AR
Back to Rotax 582UL