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 ('2072424')
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 ('2072424')
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.
N3880RC172 Nancy LLC · Euclid, OHN3883RGingras Carl A · Avondale, CON3888RGriswold Zachary S · Waunakee, WIN3889RAdams Donald C · Garner, NCN3890RWright Chad · Fredericktown, OHN3891RN3891r LLC · Ogden, IAN3896RSabatka John M · Madison Lake, MNN3897RPrice William B · Lamar, SCN3898ROverlord Aviation LLC · Melbourne, FLN3899RLockett Joseph Jr · Philadelphia, PAN3901RMuth Joseph A · Richmond, KYN3902RBotero Jorge · Alexandria, VAN3903RDanielson Bradley K · Willmar, MNN3905RShea Michael P · Nashua, NHN3906RHorning Richard · Galion, OHN3907RNexgen Aviation LLC · Ennis, TXN3908RDobson James Cody · Paradise, UTN3911RPurcell Keith A · Lima, OHN3912RBayshore Safety · Pittsburg, CAN3913RClaudy Steven A · Jessup, MDN3916RRegistered aircraftN3917RN3917r LLC · Omaha, NEN3918RWilliams Christopher · Alvarado, TXN3919RCater Tyrone · N St Petersburg, FLN3920REbrahim Ahmed · Livingston, TXN3921R3921r Aviation LLC · Broken Arrow, OKN3922REnns Lawrence P · Osteen, FLN3927RFirst Flight Corp · San Diego, CAN3928RPhillips Paul · Dover, DEN3935RBooher Daniel R · Humble, TXN3936RNelson Cliff A · Joplin, MTN3938RTaylor Joseph Frank · Tamarac, FLN3941RDemulling Michael C · New Richmond, WIN3942ROracle Aviation LLC · Omaha, NEN3944RFedorko Stephen J · Springdale, ARN3947RCarter George T · Williamston, SCN3949RLacroix Paul R · Taylor, MIN400SKCappello Dave A · Cottonwood, CAN401GTCastillo Giovanny G · Brodheadsville, PAN422RGGerwig Ellen W · Anderson, SCN465QSchmidt Fred P · Fenton, MON466SRKmt Alliance LLC · Kathleen, GAN46940Registration Pending · Como, MSRegistration pendingN483RJMccomas Darryl E · Happy Jack, AZN4960RUnited States Air Force Owner · Cannon Afb, NMN4969RUnited States Air Force Owner · Offutt Afb, NEN4971RScherer Sid S · Napa, CAN4972RUnited States Air Force · Apo, APN4974RMcpherson Marvan T · Oklahoma City, OKN4979RUnited States Air Force · Offutt Afb, NE
Back to Cessna 172H