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.
N6834VDavis James D · Hamilton, MTFirst renewal noticeN6835UBas Part Sales LLC · Greeley, CON6836UEllis Grover D · Sanford, NCN6836VHonaker Ronald R · Saint Louis, MON6837NBloom Alexsandr · Westfield, MAN6837UJohnson Aviation LLC · West Lafayette, INN6838UPethe Travis K · Littleton, CON6839UEgbert Ryke Scott · Ogden, UTN6840NJohnston Robert M · Plantation, FLN6842UThompson Matthew S · Fowler, CON6843UBoone Joe · Madison, INN6845NTriplett Jared · Mckinnon, WYN6846NBitcertificates LLC · Kalispell, MTN6846UStokely Nicholas J · Wagram, NCN6847UFolkerts Thomas A · Roseville, CAN6848NWinner William B · Durango, CON6848UKiefer Nathaniel Stephen · Del Rio, TXN6849NBig Bad Technology LLC · Hawthorne, FLN6849UShipman Terry · Flossmoor, ILN6850ULarson Steven H · Angel Fire, NMN6851URodier Michael P · Foley, ALN6852NBrown Robert I · Youngsville, LAN6853UHobson Davy R · Grapeland, TXN6854NTeel Glen A · Hays, KSN6854UChristler Flying Svc Inc · Enumclaw, WAN6855USebek Kenneth D · Guntersville, ALN6857UShabotynskyj Kathleen · Palm City, FLN6858NBarnes Kevin Lee · Greensboro, MDN6858UMattingly James P · Edwardsville, ILN6859UFischer John C · North Highlands, CAN6861NCooke Douglas L · Ventura, CAN6862UCromer Chet T · Anderson, SCN6863UHoppe Joel A · Mankato, MNN6864NStensen Craig J · Mount Juliet, TNN6864UKuch Jonathan · Capitola, CAN6866NMancini Peter A · Kenmore, NYN6867NKnox Robert W Jr · Hazlehurst, GAN6867UMesquite Metro Flying Club · Dallas, TXN6869UHostetler Kevin J · Green Forest, ARN6870UTahirovic Elmaz · Sharpsburg, GAN6872NVivian Rodney E · Cincinnati, OHN6873NWhitfield Jesse Leigh · Anacortes, WAN6875NKatlin Ethan W · Payson, AZN6876NCunneen Casey Joseph · Studio City, CAN6876UVan Der Hart Mark H · Tekamah, NEN6880VCraft Steven W · Port Saint Lucie, FLN6881NMorris Michael R · Columbus, OHN6881UElliott James C · Parker, CON6881VCox Colin T · Harbinger, NCN6882UHoecher Robert T · Anchorage, AK
Back to Mooney M20C