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 ('5870219')
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 ('5870219')
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.
N9162NMann Aviation LLC · Wilmington, DEN9163QWebb John L · Elgin, TXN918THLayton James L · Carrollton, GAN91CPBas Part Sales LLC · Greeley, CON9201AN9201a LLC · Oro Valley, AZFirst renewal noticeN9201MT-Smht LLC · Shoals, INN9201TEisenhardt Scott · Milwaukee, WIN923DFRosene Norm · Chico, CAN925JHLightning Air Group LLC · Fort Worth, TXN9269NLevenfeld Yuri · Brookhaven, GAN926DSJsrg Aviation LLC · Incline Village, NVN926KRNewton Christopher F · Kill Devil Hills, NCN927ALBravo II Sierra LLC · Dallas, TXN928KCBaldasaro Bonnie B · Clifton Park, NYN92DBBroder Alan H · Port St Lucie, FLN92ELTrue Course Aviation LLC · Flower Mound, TXN9354TJb Aero LLC · Fairview, PAN9367VKolisnyk Christopher D · Winterville, GAN937BPSouthern Aircraft Consultancy Inc Trustee · Casper, WYN93KSRose Jeffrey A · Cranfills Gap, TXN94814Lint Michael G · Sacramento, CAN94REMckinney Charles A · Indiana, PAN952RHKilo Alpha Flights · Long Beach, CAN9609URykala Martha E · Hayward, CAN9656GPappas Ryan Conner · Ocean View, DEN9680GRegistration Pending · Boerne, TXRegistration pendingN96827Zehner Mike W · Boise, IDN969RSShawn Richard N · Bradford, RIN96CBNine Six Charlie Bravo LLC · Aspen, CON96ERGunn Sean M · Colorado Springs, CON96KSMower Douglas D · Cedar Ridge, CAN97136Lufertarg Group Inc · Mineola, NYN975RJDavison Michael J · Big Rapids, MIN97642Bravo Zulu Aviation Inc · Chattanooga, TNN9777FStubstad Garrett · New Town, NDN97983Wintill Gregory S · Roanoke, TXN97DMRegistered aircraftN981SMMcintosh Steve A · Jefferson City, MON984TDJones Joseph D · Broken Arrow, OKN984VWSkyhawks Inc · Westminster, CON98989Aurellium Corp · Bettendorf, IAN9899ARhodes William D Jr · New Tazewell, TNN989PMGasper Michael J · Malvern, OHN989TGSouthern Airmotive Inc · Texic, NMN98BRGrant Brian · Durham, NCN9909ESmith C Gary · Gretna, LAN9918GRoettger Investment Corporation · Evansville, INN9930SGpm Flyers LLC · Colleyville, TXN9932SNeboschick Ashley B · North Charleston, SCN993JBLarson John H Trustee · Bend, OR
Back to Mooney M20J