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 ('2072418')
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 ('2072418')
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.
N9379HCitizen Air LLC · Port Angeles, WAN9387HAirline Transport Professionals Corp Of USA · Wilmington, DEN9390HBenke William A · Collinsville, OKN9392HVc Flights LLC · Miami, FLN9394HJohnson Chester F III · West Ossipee, NHN9395HInosculation Air LLC · Summerville, SCN9396HHaley Robert Jay · Livermore, CAN9397HFlight World Inc · San Juan, PRN93JSNeptune Aviation Services Inc DBA · Missoula, MTN93KKMonmouth Area Flying Club · Lakewood, NJN9400HRoach John C · Lawrenceburg, KYN9401HConstantine Costas T · Newington, CTN9404HSowell Richard G · San Jose, CAN9407HB2w Corporation · Winona, MNN9413HPayne Rachel L · Geneva, FLN9415HDungan William T Jr · Marion, VAN9425HWingsleasing LLC · Wichita, KSN9438HBering Capital LLC · Anchorage, AKN9443HAllport Bruce E · North Hollywood, CAN9444HPrestige Worldwide Aerospace LLC · Panama City, FLN9445HBrown Max K · Cushing, OKN9447HLang Julia A · Greensburg, PAN944CBCalifornia Baptist University · Riverside, CAN9452HFreeland Thomas W · Early, TXN945TC R Transport Inc · Wilmington, DEN9468HShouse Andrew · Flagstaff, AZN9469HAirplanes And Attitude LLC · Mckinney, TXN9472HMulder Terry A · Appleton, WIN9476HHelicopter Partners Inc · Wellington, FLN9480HMoynihan Patrick J · Lakeville, MNN9484HN9484h LLC · Wheeling, ILN9490HNovak Rickson J · Pine City, MNN9492HSchodack Aviation Association · Ghent, NYN9495HNelson Flying Service LLC · Lansford, NDN94HJGable Taylor Lee · Nicholson, GAN9502HYoung Roger A II · Wasilla, AKFirst renewal noticeN9504HPatterson Clifford Wayne · Murphy, TXN9505HFinal Approach Aviation LLC · Danville, CAN950MEN950me LLC · Manassas, VAN9510HRegistered aircraftN9512HTracy Patrick J · Maddock, NDN9513HHigh Flight Academy LLC · Allison Park, PAN9514HFrerichs John E · Gurley, ALN9521HJordan Recreation Development LLC · Clinton, TNN9522HUrbas Robert M · Rockford, ILN9523HVictor James A · Kingsville, OHN9526HAbove The Haze LLC · San Lorenzo, CAN9534HBotezatu Florin · Gig Harbor, WAN9535HNorthwest Wings LLC · Hillsboro, ORN9536HSampson Kelly J · Canby, OR
Back to Cessna 172M