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 ('2072716')
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 ('2072716')
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.
N2422RAbecca Corp · Jackson, MIN2424RCurlee Derek · Yoakum, TXN2425RDietze Weldon W · Seguin, TXN2426RRiley Aerospace LLC · Sebastian, FLN2428RAltimeter Inc · San Marcos, TXN2432RLindsley Daniel · Vulcan, MIN2433RRohrer Walter J · Gallatin, TNN2436RSilva Gary · Yerington, NVN2437RBlackwelder John W · Columbia, KYN2441RBelly Acres Capital And Management LLC · Memphis, TNN2443RYoung David E · Wasilla, AKN2444RClancy Michael · Rifle, CON2452RKnutson Wayne R · Thompson, NDN2454RBrown Timothy L · Liberty Lake, WAN2455RLaw John · Marina, CAN2456R5625t LLC · Little Falls, NYN2457RPicotte Paul C · Fallon, NVN2459RGardiner Timothy M · Gardendale, ALN2461RFx Mining LLC · Haines, AKN2464RStoffers William · Samoa, CAN2466RToland Beldon T · Dodge City, KSN2467RSparks Eric D · Missouri Valley, IAN2468RCruson Dale E Trustee · Ontario, ORN2469RKrehbiel Doug W · Moscow, IDN2471RFykerud Eric J Sr · Bend, ORN2472RVac New Inc · China Village, MENon-citizen corporation, flight hours not reportedN2473RRonald O Holcomb LLC · Lapeer, MIN2476RBascom Richard J Trustee · Elkhart, IAN2477RJohnson Michael W · Kensington, OHN2478RWeber Alan M · Manteca, CAN2481REngh Robert G · Laurel, MTN2483RSkydive Twin Cities LLC · Baldwin, WIN2486RCain James W · Big Rapids, MIN2487RCummings Sean · Lombard, ILN2488RCorprew Gerard A · Callao, VAN2490RBirdie Air LLC · Wichita, KSN2491RDaly John M · Fort Worth, TXN2495RSale Reported · Saint Augustine, FLSale reported, canceledN2498RJohnson Christopher A · Pampa, TXN24REMelendez Jesus · North Miami, FLN2685XWorden Andrew · Burlington, CON3006YWissner Martin L · Carpenter, WYN300KTKarnowski Ventures LLC · Manhattan, KSN302USolomon Mark Trustee · Wilmington, DEN3100SSinnissippi Aviation LLC · Beloit, WIN3105SMorgan A Douglas · Madera, CAN3108SLac Avionics Inc · San Jose, CAN3111SMiller Bruce E · Lake Oswego, ORN3112SKcsi Aerial Patrol Inc · Bakersfield, CAN3115SHamric James H · Ward, AR
Back to Cessna 182G