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.
N4328HCalabretta Charles J · Hanford, CAN432MJ43rd Aviation Flying Club Inc · Wethersfield, CTN4335HRiisnaes Alf Kare E · Rapid City, SDN4336HKozak Frank E · Santa Maria, CAN4339HKaufman Timothy H Trustee · Saint Charles, MIN4341HGunstream Jesse B III · League City, TXN4346HStrickland Mark J · Arlington, TXN4350HKieser Investments LLC · Bloomington, ILN4361HSazhin Michael · Brooklyn, NYN4374HAlexander Chang Lee · Menifee, CAN4394HFarabaugh Mark J · Owego, NYN4395HHorizontal Aviation Ltd Inc · Pinehurst, NCN43CAThomas Nicholas O · Columbus, KSN43JAJersey Aero Club · Lakewood, NJN4413HCharlton Jeremiah · Rockford, ILN4422HWitherspoon Brian · Ben Lomond, CAN4435HEmtee Air LLC · Kalispell, MTN4437HSander Elliot G · Guilford, CTN4443HMalik Arif S · Frisco, TXN4448HNorthwest Iowa Flyers LLC · Everly, IAN444BHEbert Joel E · Peru, INN444JJEnviro Aviation LLC · Fort Lauderdale, FLN4452HMick Hill Enterprises · Cedarpines Park, CAN4459HClements Edward L · Fruita, CON445SHAgster Air LLC · Granbury, TXN4461HJohnson Airspray Inc · Argyle, MNN446CBEastern Stearman Inc Trustee · Leesburg, VAN4472HSalamon Uri · Boerne, TXN4485HFrancesco Grasso · Lutherville, MDN4486HJennings Sabina · Carson, CAN4497HEn Route Holdings Inc · Warrensville, NCN4498HWestervelt Susan · Nutley, NJN44NSHunt Lionel Mark · Groveland, CAN44TSNapier Mark R · New Bern, NCN44ZTJensen Erik N · Madison, WIN4501HBrown Kevin · San Dimas, CAN4509HGolding Lee · Brookline, MON4511HVeritas Urbis Economics LLC · Groveland, CAN4517HHopkins Larry G · Cameron, MTN4522HGlaser Arthur E · Crest Hill, ILN4524HSaka M Demir Trustee · Quincy, ILN4526HJohnston Robert K · Sylvania, GAN452XJohnson Robert Gail Jr · Yorba Linda, CAN4532HAdvanced Flight Systems Inc · Canby, ORN4535HMurray Brent S · Great Falls, MTN4536HColorado Flight Operations LLC · Colorado Springs, CON4558HTjr Inc · Bellevue, NEN4566HBeresford Emil E · Cape Coral, FLN4569HPowell Randy N Trustee · Elko, NVN4583HPiehler David A · Wausau, WI
Back to Mooney M20J