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.
N5354DGonzalez Alejandro B · El Paso, TXN5356DDethlefs Robert L · Clackamas, ORN5357EHoffman Dennis M · Winchester, VAN5357JArizona Bravo Lima LLC · Phoenix, AZN5358DXin Han Aviation LLC · Atwater, CAN53600Kdrd Holdings LLC · Texas City, TXN5360JFly Montana LLC · Miles City, MTN5366JSlipstream Aviation LLC · Calera, ALN5374JMiles Brian R · Lake Jackson, TXN5375JDaviss Joseph A · Sylacauga, ALN5376JTss Aviation LLC · Conyers, GAN5377DDesantis Anthony · Memphis, TNN5378DMustang Sally Aviation LLC · Camden, SCN5378ENuxoll Randy G · Eagle, IDN5382DEagles Flying Club · Saint Charles, MON5383DTong Sheng Aviation LLC · Irvine, CAN5385DDg Aviation Services Inc · Merritt Island, FLN5385JAerowood Aviation LLC · Monroe, NCN5386DDuffys Aircraft Sales & Leasing Inc · Neillsville, WIN5386JNaylor-Adams Aviation LLC · York, PAN5396ESorbi Aviation Inc · El Cajon, CAN5397DRandall William G · Oklahoma City, OKN5399JMann Aviation Inc · Long Beach, CAN53FBBiniewicz Frank B · Downers Grove, ILN53JVan Way Dillion J · Lafayette, LAN5400JErwa Mohamed E · Leander, TXN5402EOsprey Holding Company LLC · Foley, ALN5408ECutbirth Henry R · Monahans, TXN5409JKelley Aircraft LLC · Weyers Cave, VAN5415DSilverhawk Aviation Academy LLC · Caldwell, IDN5416EWade Justin B · Calhoun City, MSN5423ESkywarrior Flight Training LLC · Pensacola, FLN5423JRialto Christian Flyers Club Inc · Bradenton, FLN5424JFusano Lisa A · La Crescenta, CAN5426JMedia Stew LLC · Carson City, NVN5432EMilwaukee Aero LLC · Milwaukee, WIN5433EAty Aviation Inc · Watertown, SDN5434DSierra Lima Aviation LLC · Riverton, UTN5434EMiller Shane D · Cherokee, OKN5435EWings Over Texas Holdings LLC · Denton, TXN5435J22december LLC · Bartlett, ILN5436EKitsap Aviation Squadron Inc · Southworth, WAN5437JMiloud Chadd K · Fort Worth, TXN5440EK & A Aviation Inc · Barnegat, NJN5444JHm Aviation LLC · Cape Fair, MON5446DJ And D Petroleum Co · Tallahassee, FLN5455JFriend John M · Ozawkie, KSN5457DSanders Flight Training Center Inc · Jasper, ALN5457ETravis Gregory R · Bloomington, INFirst renewal noticeN5457JRegistration Pending · Chino, CARegistration pending
Back to Cessna 172N