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 ('2072732')
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 ('2072732')
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.
N735JNWehrman Milton W · Hunter, KSN735JQHeppe Dale · Lynn Haven, FLN735JRSearcy Farm Supply LLC · Searcy, ARN735JXBendett Michael James · Chestnut Hill, MAN735KALange Marc B · Spokane, WAN735KKLockhart Flying Club · Lockhart, TXN735KSSquires Rodney M · Willow Creek, CAN735KTEde Transport LLC · Charleston, WVN735KXAndrzejewski Keith D · Ridgefield, CTN735KYJohnston Johnny C · Hernando, MSN735KZDavis Robert L Jr · Hugoton, KSN735LB5 Lima Bravo LLC · Bonita, LAN735LCGud Luk Cruzin LLC · Cincinnati, OHN735LDRappaport Joel A · Round Rock, TXN735LEReynolds Aviation LLC · Lewes, DEN735LFHipp Air LLC · Evansville, INN735LHBoeing Employees Flying Association Inc · Renton, WAN735LKBell Scott T · Belgrade, MTN735LLHeath Jimmy · Lynn Haven, FLN735LMKalman Lajos E · Spring Hill, KSN735LQSkyview Premier Properties LLC · Stony Brook, NYN735LTFrowe Robert · Lake Dallas, TXN735LWEdwards Wallace · Commerce Township, MIN735LXTraut Lake E · Riverside, CAN735LZHigh Flight Inc · Enid, OKN735MHKxnx Holdings LLC · Cottontown, TNN735MNCurtis Kyp · Victor, MTN735MREdwards John S · New Port Richey, FLN735MSPatel Chintan S · Ann Arbor, MIN735MTGr8daynevada LLC · Carson City, NVN735MULucas Parker D · Imbler, ORN735NCMarch Renardo · West Palm Beach, FLN735NDNowater Aviation LLC · Worland, WYN735NGGreen William T · Mesa, AZN735NHN735nh LLC · Omaha, NEN735NKWhite Jeff · O Fallon, ILN735NMLtf Aviation LLC · Urbandale, IAN735NQHughes Kelli L · Trophy Club, TXN735NSDunn Scott R · Sandpoint, IDN735PBHavens Harold J · Ellensburg, WAN735PDViola LLC · Monrovia, CAN735PEWalker John Leonard III · Cullman, ALN735PHBrowning Charles H · Woodbine, MDN735PKN735pk LLC · Story, WYN735PMJm Aviation I LLC · Little Falls, MNN735PRTwisted Distribution LLC · Burleson, TXN735PSN735ps LLC · Bryan, OHN735PTCastillo Steven J · Big Bear Lake, CAN735PWN735pw LLC · Petal, MSN735PXNalevanko Thomas A · Alpine, WY
Back to Cessna 182Q