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 ('5870208')
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 ('5870208')
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.
N9178QMartinez Manuel G · Downers Grove, ILN9179VVinter Mooney LLC · Philadelphia, PAN9184VCloud Distributing LLC · Austin, TXN9194VAlva Aviation LLC · Nacogdoches, TXN9195VHunter Robert J DBA · Montgomery, ALN91YRau Lois M · Liberty, KSN9201VHay Edward P Jr · Chico, CAN9202MCarlson John C · South Haven, MIN9204VDahle Avenue Aviation LLC · Faribault, MNN9206MCrews William J · Jacksonville, FLN9206VRegistered aircraftN9211MSowers James Dalton · Park City, KYN9211VMorrissey Thomas A · Peachtree City, GAN9214VGostomski Michael J · Yacolt, WAN9216MLewellen Richard H · Mount Vernon, WAN9217MMullenbach Arnold D · Tucson, AZN9218VTerrell Aviation Inc · Terrell, TXN921WC7 Corp · Orlando, FLN9222VSoco Scuba LLC · Austin, TXN9224VBevington Carl R · Middle Point, OHN9227MMullis Brent S · Garfield, GAN9232VFerri Lawrence E · Lake Worth, FLN9237VPortouw Lawrence J · Huachuca City, AZN9239VRegistration Pending · Louisville, MSRegistration pendingN923EZE Z Air LLC · Wilmington, NCN9241MBellinger John · Wexford, PAN9242VHurley Gregory · Capon Bridge, WVN9244VGibbs Richard L · Palm Coast, FLN9246VBibbs Kevin · Copperas Cove, TXN9249VRobertson Scot H · Tribune, KSN9251MFelix Eric · Oshkosh, WIN9252MStarfox Aero LLC · Hays, KSN9254VLeyden Jar LLC · Greeneville, TNN9256MLone Star Magni Gyro Inc · Taylor, TXN9256VDirschka Paul · Blandford, MAN9257MMouser Ryan D · Paragould, ARN9260VBravo Aero LLC · Concord, NCN9261MPickett Trina M · Riverside, CAN9263VOrton Leon J · Nibley, UTN9268VNelson Edward C · Manorville, NYN9270VPhilippi Harrold Mark · Metairie, LAN9271MCantelmi Richard L · Bethlehem, PAN9272MSearle Jacob · Kuna, IDN9277MHodde James C · Mckinney, TXN9281MJakobsen Anders M · Norcross, GAFirst renewal noticeN9281VJohnson Jerry W · Westlake, TXN9282MRainey Michael N · Cleveland, TNN9285VEllsworth Bryan E · Garden City, UTN9287VRuschman Vaughn M · Boise, IDN9289VSteel Richard Allen · Milford, NH
Back to Mooney M20C