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.
N332JJBialek Joseph · New Smyrna Beach, FLN332JNMenzel Michael Alexander Jr · Peculiar, MON333CDIct Flyilng LLC · Pelham, ALN333VCRegistered aircraftN334ARHouldson Consulting Inc · Morrison, ILN335BBVantrease David A · Wills Point, TXN335ERLandgraf Scott A · Buffalo, MNN337MCLandavazo Joseph · Albuquerque, NMN33YZJenkins Blake T · Lakeland, FLN340BMInternational Air Services Inc Trustee · Carson City, NVN343DMHess Eric J · Cave Creek, AZN34LLGwizz Financial LLC · Wausau, WIN34PWContinental Expedited Services · Clarksville, TNN34SAMiller Keaton · Newburgh, INN3510HNix Terry W · Golden, MSN3512HR & D Plane LLC · Longwood, FLN3513HTurbett Robert E · Penfield, NYN3526HLyons Donald F · Cheverly, MDFirst renewal noticeN353BWHall Aviation LLC · Ithaca, NYN3545HBurkett Aviation LLC · Boone, NCFirst renewal noticeN355DTForster George A · Port Townsend, WAN355RLRegistered aircraftN35ELB&W Air LLC · Lincoln, NEN365BCFisher Charles P · North Charleston, SCN365JTBe-A36 Inc Trustee · Wilmington, DEN3687HRunia Allan D Trustee · Gold Hill, ORN369RPRegistered aircraftN36CEHawkes Delray · Sequim, WAN3703HTsyupka Andriy · Hinsdale, ILN3705HGeyer Donovan · Palo Cedro, CAN3706HDurand Ryan A · Hermantown, MNN3712HSpencer James W · Valley Lee, MDN3716HSky Deals LLC · Kearney, NEN3742HLocurto Anthony C · Alexandria, VAN374SMN374sm LLC · Orlando, FLN3751HSoftcomm Aviation Inc · Irvine, CAN3755HWeltman Brian G · Pasadena, CAN3766HN3766h LLC · Portland, ORN3768HArrow Electric Contractors LLC · Kent City, MIN3770HGrandy Boyd · Arcadia, CAN3774HRegistered aircraftN377JFTranchina George R Jr · Lacombe, LAN377VKFoy Carol M · Spicewood, TXN3790HEmerson David E · Sugar Land, TXN3792HWalbright Phil · Zanesfield, OHN3795HMartin Timothy · Queen Creek, AZN3796HMceachern Mary Margaret · Wilmington, NCN37GDKmsb Management LLC · Sarasota, FLN3803HStaib Matthew · Cambridge, MAN3813HJohnson Mark A · Cypress, TX
Back to Mooney M20J