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 ('5870222')
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 ('5870222')
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.
N9140ZMobley Charles D · Douglasville, GAN9142FGontarek Robert E · Plano, TXN9142ZLippity Clippity Aviation LLC · Muskegon, MIN9143XCt King Airplane LLC · Snohomish, WAN9144CMazzara David J · Collierville, TNN9145XHk Aero LLC · Wilmington, DEN9147XInfinity Aviation Group LLC · Nashua, NHN9148DSky Blue Aviation LLC · Hershey, PAN9148WD & D Kaye Inc · Santa Clara, CAN9149PJustack Aviation Inc · Columbus, INN9149XJohnson Daniel C · Mount Hope, KSN9149YBest Crane & Equipment Co LLC · Wilmington, DEN9150GCampbell Ken · Lincoln, CAN9150ZV T Whitlock Inc · Lake City, SCN91516Johnsoon Miller · Huntsville, ALN9151XHawkins Aviation LLC · Gilbertsville, KYN9153YAkn Inc · Crystal, MNN9153ZDanam Aviation LLC · Queen Creek, AZN9154W5 Degrees North Inc · East Stroudsburg, PAN9155FMahoney Michael K · Neillsville, WIN9155YGet There LLC · Boise, IDN9156YRegistered aircraftN9156ZEdney James A Md · Omaha, NEN9157JAkn Inc · Crystal, MNFirst renewal noticeN9157SAdverse Yaw LLC · Albuquerque, NMN91595Ristrim Eric · Henderson, NVN9159CConlon James E III · Longmont, CON9161DSchlesinger Warren · Page, AZN9161EKurtz Andrew · Boise, IDN9161NCorvallis Rapid Transit LLC · Corvallis, ORN9161UHeron Kyle B · Modesto, CAN9161YFonville David N · Cresson, TXN9162DWeagle Aviation LLC · Birmingham, ALN9163CZaparovanny Alexey · Westford, MAN9164ZN9164z LLC · Fayetteville, GAN9167JNelson Ryan M · Appleton, WIN9170HWeight Steven A · Fairview Park, OHN9170RPage David L · Bermuda Dunes, CAN91727Qualitair LLC Trustee · MichelstadtN917SELarson Donald C · Evanston, WYN919BTGeorges Thomas A · Santa Teresa, NMN924TFRegistered aircraftN93CDDe Leon Jonas · New York, NYN96JDMorehouse Gregory · Missoula, MTN977LRN977lr LLC · Englewood, CON98JTMossip Paul · Blairstown, NJN994USDelta Kilo Foxtrot LLC · Littleton, CON999HJSugiono Yudi S · Redlands, CAN999UQualitair LLC Trustee · Michelstadt
Back to Mooney M20M