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 ('2072724')
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 ('2072724')
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.
N2691RLongsview Holdings LLC · Lewes, DEN2692QHill Jonathan Troy · Taylorsville, KYN2692ROliver Craig J · Orion, MIN2693R15 Rides LLC · Manteo, NCN2694QMiller William A Jr · Okeechobee, FLN2695QKirbco Aviation LLC · Doniphan, MON2695RAccardo Paul A · Zwolle, LAN2696QKlauber Gerald · Lake City, FLN2697RMaring Matthew D · Westley, CAN2698QButler John L · Omak, WAN2698RWeishaupt Louis R · Mackinaw, ILN2700PSean Steward Md Pc · Hillsboro, ORN2702QZaenkert Robert C · Okeana, OHN2703QEdwards Daniel M · Wendell, NCN2704QWalker Dennis R · Anchorage, AKN2705QAdkins Emily L · Statesville, NCN2708QElkhorn Aviation Inc DBA · Baker City, ORN2712QGrotbeck Carter L · Albuquerque, NMN2713QJeff Jones Aircraft Company LLC · Quincy, WAN2718QJenerette Marcus · Galivants Ferry, SCN2720QDelta Yankee Aviation LLC · Anguilla, MSN2721QN2721q LLC · Stuart, FLN2727QEstes Gregory T · Jonesville, VAN2729QCraft Phyllis C · Damascus, GAN2730QSkylane Corp · Pittston, PAN2731Q31q LLC · Boise, IDN2734Q1175 Bangtail Way LLC · Greycliff, MTN2735QRegistration Pending · Hearne, TXRegistration pendingN2736QBachich George A · Napa, CAN2742QKibler James · Indialantic, FLN2743QSzigeti David J · Gaylordsville, CTN2745QAero Docs LLC · Butte, MTN2747QMosier Michael J · Kalamazoo, MIN2748QDavie Walter C · Los Angeles, CAN274DBAlvray LLC · Enumclaw, WAN2751QValu Prop LLC · Fargo, NDN2752QAnspaugh Bruce E Trustee · La Crescenta, CAN2753QFull Throttle Aviation LLC · Terlingua, TXN2755QBlessed With Wings LLC · Queen Creek, AZN2756QLett Brian R · Eden Prairie, MNN2757QFive Seven Quebec Incorporated · Lake Stevens, WAN2764QLong Donald G Jr · Gaston, ORN2766QThree Airmigos LLC · New Port Richey, FLN2769QPrecision Truck Equipment Inc · Lansing, ILN2774QRdj Brothers Trucking Inc · Bigfork, MTN2775QRay Chris J · Ironside, ORN2781QGibboney Phillip M · Roseville, CAN2782QBauer Aviation LLC · Reese, MIN2787QThorell Farms Inc · Loomis, NEN2788QKahle Matthew N · Paw Paw, MI
Back to Cessna 182K