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 ('2072726')
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 ('2072726')
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.
N3375RRoyellair LLC · Stone Mountain, GAN3376RStumm Robert W · Cadott, WIN3377RLonestar Aeronautics LLC · Paige, TXN3380RHunter Robert R · Springville, PAN3382RWatch Out LLC · Scottsdale, AZN3383RDeatley Derek · Mohave Valley, AZN3384R3384 Romeo LLC · Jackson, MON3385RHill David A Jr · Needham, MAN3387RSkypartners LLC · Buhler, KSN3388RFamily Air Fares LLC · Wilmington, DEN338LMSisk Stephen A · Greenville, ILN3394RCurren Patrick V · Green Bay, WIN3395RJohnston Osceola Holdings LLC · Dallas Center, IAN3396RSimmons Craig · Houston, TXN3397RKcsi Aerial Patrol Inc · Bakersfield, CAN3399RGleason Joseph P · Knoxville, TNN33DMGray Chad T · Garden Valley, IDN3402RBurton Darrell · Somerset, KYN3404RHuffstetler Don · Mount Vernon, TXN3408RFronapfel Hannah A · Palmer, AKN3409RAnderson Curtiss B · Heber Springs, ARN3410REpperly Scott C · Montague, CAN3411ROgp LLC · Wilmington, DEN3414RDanninger James · Kirkland, WAN3417RN3417r LLC · Wichita, KSN3419RMcnutt Dava M · Port Angeles, WAN3420RBietz Jason L · Tripp, SDN3424RMulder Field Inc · Ivanhoe, MNN342MMJohnson Aaron M · San Ramon, CAN3431RGuibaud Albert G · Monrovia, CAN3433RAlty It Solutions LLC · Milan, MIN3434RBurkhardt James · Brookings, SDN3437RSmith Darrin M · Torrance, CAN3438RDauenhauer Colby · Springtown, TXN3441RQualtieri John E · Fallon, NVN3443RBertrand John E · Trion, GAN3448RFour Eight Romeo LLC · Shallowater, TXN3449RRobinson Timothy A · Casa Grande, AZN3451RBurkett Aerial Spraying · Coleman, TXN3452ROreagan Trenton David · Soldotna, AKN3459RRtd Aviation LLC · Hillsborough, NJN3473RBrooks Gregory Keith · Green Cove Springs, FLN3475RMccullough Hugh J · Glennville, GAN3476RTibbs Properties LLC · Franklin, LAN3479RM S Davidson Enterpries Pc · Laurel, DEN3483RCentury White Worldwide Inc · Casper, WYN3484RTouch And Go Aviation LLC · Jackson, MNN3489RKcsi Aerial Patrol Inc · Bakersfield, CAN3490RFreiberger Gary D · Fort Lauderdale, FLN3495RC182 Flyers LLC · Las Cruces, NM
Back to Cessna 182L