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 ('2072434')
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 ('2072434')
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.
N5268JReach For Skies LLC · San Antonio, TXN526WRFlorida And Caribbean Flight Training LLC · Punta Gorda, FLN5277EJefredo Corp · Zephyrhills, FLN5278DN5278d LLC · Dover, DEN5279DDay Aviation Inc · Wilmington, DEN5279GArnold Jason Mcree · Watkinsville, GAN5280EStreeter Byrand DBA · Newcastle, WYN5280MN5280m LLC · Elizabeth, CON5281JHowell Jason · Newaygo, MIN5283EYummy Apple LLC · Mesa, AZN5283JMarianas Air Transfer Inc · Tinian, MPN5284DCharlie Lima 1 LLC · Jacksonville, FLN5284EIntermill Alice R · Volga, SDN5286EButler Bill · Juntura, ORN5287ELin LLC · Dunn, NCN5289EFlightco Inc · Swainsboro, GAN5291EBreslin Denis M · El Cajon, CAN5292DAftcloud Inc · Ontario, CAN5292EJam Three LLC · Saint George, UTN5295ETimbers Flying Club · West Branch, MIFirst renewal noticeN5295GJohnston Robert · Hico, TXN5298DMorcom Aviation Services Inc DBA · Everett, WAN5298JBagamaspad Alan M · Reseda, CAN5299DPremier Flight Center LLC · Hartford, CTN529CANeufeld Don I · Fairview, OKN529LFEnterprise Aviation Services LLC · Albuquerque, NMN5301EMaxwell Don P II · Longview, TXN5303EQuinn George F · Amherst, NHN5304EDornink Farms LLC · Freeport, ILN5304FHurt J William · Hachita, NMN5306EN5306e LLC · Ashburn, VAN5309JRegistered aircraftRegistration pending, pending cancellationN5310DD & S Aviation LLC · Spring, TXN5314E57d Flyers LLC · Shelby Township, MIN5317DMonroe City Aviators LLC · Palmyra, MON5318EBishops Ltd · Virginia Beach, VAN5319DCoachron Investments LLC · Grosse Ile, MIN5323EMaierhoffer Henry F · Sylvania, GAN5331DPurdue Aviation LLC · West Lafayette, INN5334DProfessionals Aviation Co Inc · Millersburg, OHN5335DPeltz Matthew J · Ringsted, IAN5336DFerguson Bart M · Argyle, TXN5339DTang Hong-Ming · San Dimas, CAN533SJLns LLC · Wichita, KSN5342DCornell Timothy R · Hartland, WIN5344DAirgo Inc · Centralia, ILN5346DBoldflight LLC · Greenwood, INN5346EOsprey Holding Company LLC · Foley, ALN5348DSwaz Aviation LLC · Mesa, AZN5349DFisher Randall A · Salem, OH
Back to Cessna 172N