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.
N737JHMcdermotts Letsfly LLC · Somerton, AZN737JJAvid Aviation LLC · Gilbert, AZN737JMMccormack June · Borrego Springs, CAN737JQPorter Timothy Charles · Bloomington, INN737JRG&M Aircraft Inc · Wheat Ridge, CON737JUFussell Tracy L · Mc Rae, GAN737JXR&R Aero Services LLC · Eden Prairie, MNN737JYWright Robert Gene · Kearney, MON737KCH & H Aviation Enterprises LLC · Fairfield, OHN737KE247 Aviation LLC · Palm Coast, FLN737KGRamp 106 LLC · Lynn Haven, FLN737KJRed-Tailed Hawks Aviation Academy · Mukilteo, WAN737KMSmith Daryl N · Coventry, CTN737KQZuidema Herbert L Trustee · Redding, CAN737KWJcil LLC · Hudsonville, MIN737KXBroadseam Aviation LLC · Kodak E, TNN737KZNeptune Aviation Services Inc · Missoula, MTN737LGAirborne Mgmt LLC · Dublin, OHN737LHCenterline Aviation LLC · Fredericksburg, VAN737LKTotal Flight Aircraft Leasing LLC · Apex, NCN737LLBreyer Michael K Trustee · Crystal Lake, ILN737LPNorris Brent I · Camarillo, CAFirst renewal noticeN737LREagle Home Medical Corp · Roanoke Rapids, NCN737LXN737lx LLC · Manassas, VAN737LYN8074e LLC · Jackson, NJN737LZMoore Steven J · West Ossipee, NHN737MELake Elmo Aero LLC · Lake Elmo, MNN737MFCarter Flygare Inc · Sacramento, CAN737MHMls Aviation LLC · Yorba Linda, CAN737MLWings Over Texas Holdings LLC · Denton, TXN737MPButte Aviation Inc · Butte, MTN737MUTrade Winds Aviation Holdings LLC · Lewes, DEN737MYN737my LLC · Mccall, IDN737NCGreenville Flight LLC · Greer, SCN737NFMy Way Aviation LLC · Weston, FLN737NGTactical Integrated Training Solutions LLC · San Antonio, TXN737NJSutton Aircraft Salvage LLC · Palmer, AKN737NLMoravan Gregory W · Portland, ORN737NMCivil Air Patrol · Maxwell Afb, ALN737NNSeyffert Charles M · Hampton, VAN737NRKenmore Air Harbor LLC · Kenmore, WAN737NUOracle Aviation LLC · Omaha, NEN737NVMelbourne Flight Training LLC · Melbourne, FLN737PCMurray Raymond R · Harriman, TNN737PHPatriot Management Co Inc · Solvang, CAN737PJChawilder LLC · Chattanooga, TNN737PMSocal Aviation Inc · Chino, CAN737PPAir One Aviation LLC · Cedar City, UTN737PRRoderick Kevin · Newport, RIN737PVBattle Creek Powersports LLC · Jasper, TN
Back to Cessna 172N