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.
N6711NHanna William R · Castle Rock, CON6711UUlassin Kyle B · Corvallis, ORN6712USchell Kerry A · Arvada, CON6713UHinds Casey L · Seattle, WAN6715NWomble Phillip A · Enid, MSN6716UPickworth Jonathan · Philadelphia, PAN6717NGaskill David E · Toledo, WAN6718UBerra Robert J · Burtonsville, MDN6719URegistered aircraftN6720UGilt Michael F · Raleigh, NCN6723UHohn Jeffrey A · Townville, SCN6725NB Ryan Enterprises Inc · Lynnfield, MAN6727NCroney Mark J · Lawrenceville, GAN6728UReed Walter D · Lahoma, OKN6729NAnderson Douglas E · Winchester, ORFirst renewal noticeN672TPLong Timothy · Weatherford, TXN6730UOsaginwen K Ayiyi · Goodyear, AZN6731UGondouin Francis P · San Rafael, CAN6733UHeld Joseph Edward · Cooksville, MDN6743NHollingsworth Michael J · Phoenix, AZN6745NGonzalez David · Hollywood, FLN6745UBall Aaron J · Pocatello, IDN6747NBolt Almos L Jr · Montgomery, TXN6747UDevuyst Richard C · Pampa, TXN6749NFosburgh Kevin J · Las Cruces, NMN6750UFischer James C · Falls City, NEN6751NParr Matthew R · Wellsville, PAN6752ULucarelli Michael · Surprise, AZN6753NHarmon Benjamin P · Olive Branch, MSN6754NCasady David E · Harriman, TNN6756UBergland John E · Santa Monica, CAN6757NCoody John A · Idaho Falls, IDN6757UScherger Mark A · Herndon, VAN6758NZwerko Kevin C · South Plainfield, NJN6758UN6758u LLC · Linden, MIN6759UHodgson Michael D · Saint Francis, WIN6761UJaeger Howard E · Claremore, OKN6762NTaylor Norman A · Fayette, ALN6763NRegistration Pending · Minden, NVRegistration pending, pending cancellationN6766NFoley Erik J · Henderson, NVN6767CSilverstein Devyn · Austin, TXN6768NPorthouse Chris · Bellingham, MAN6768UBranson Randel L · Eclectic, ALN6769NCausey Kevin L · Bainbridge, GAN6769UWard Leonard · Preston, IDN676NLoftus Timothy P · Mclean, VAN6771VBrice Michael · Dickinson, NDN6772NHapp Michael E · Valley Center, KSN6773VSouthern Mooney Inc · Wilmington, DEN6774UFair Weather Holdings LLC · Centennial, CO
Back to Mooney M20C