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 ('2075816')
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 ('2075816')
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.
N1365MDaftarian Michael M Md · Paradise Valley, AZN1368SN1368s LLC · Eau Claire, WIN1370SGolfbanks Leasing Partnership · Geneva, INN1374SRenninger Log Homes · Meeker, CON1376MBauman Cecil Davis · Nashville, TNN1376SClarklind Farms · Tulare, CAN1378SEngle William A · Bend, ORN1379SMorris William Alan · Newnan, GAN1382MRegan Arthur R · Green Valley, AZN1384SAdventure Aviation LLC · Fresno, CAN1385MPecha James C · Binghamton, NYN1386MJohnson Shannon L · Granite Falls, MNN1386SLangel Joseph J · Lakeville, MNN1387MJ&D Aero LLC · Wilmington, DEN1387SGalaz Nick Anthony · Lake Havasu City, AZN1388SCowboy Taxi LLC · Payson, AZN1391SWysong Charles J · Hickory, NCFirst renewal noticeN1392SAbc Flying Club Inc · West Mifflin, PAN1394SGoodman Donald J · Bellingham, WAN1395SGarcia Robert W · Floresville, TXFirst renewal noticeN1397SKnotty Aviation LLC · Fort Myers, FLN1398SOff The Charts LLC · Kalispell, MTN1399MRegistered aircraftN1399SDesmond Brett Kyle · Mars, PAN13WTBentz George T · Missoula, MTN1402SJohnston Matthew A · Ventura, CAN1403SFarnsworth Scott · Crestwood, KYN1404SRegistration Pending · Englewood, CORegistration pendingN1405MWilson George W · Tucson, AZN1405SVickers David A · Douglas, GAN1407SCaesar Wings LLC · Ubly, MIN1408SFrickel Well Service LLC · Atkinson, NEN1412SJ&J Aviation LLC · Thedford, NEN1413SAgillaire Inc · Colleyville, TXN1415MJ T Air LLC · Cleveland, ALN1416MTerra Firma Aviation LLC · Bowman, CAN1417MRegistered aircraftN1417SCooper Patrick R · Houston, TXN1419SKingdom Air Corps · Sutton, AKN1420SSmall Edward D · Fulshear, TXN1421SHoversland Leroy Dvm · Ronan, MTN1426MKing Corbin B · Lubbock, TXN1428MBaja Air LLC · Wilmington, DEN1430MSyme Brian James Shannon · Redmond, WAN1431MDmd Aviation LLC · Wilmington, NCN1433MRegistered aircraftN1435SGet The Noz Inc · Coeur D Alene, IDN1438SAddamo Vincent R · Porterville, CAN143RMOft7 LLC · Ponca, ARN1440SPolkowske Leroy A · La Jara, CO
Back to Cessna 182P