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 ('2072738', '2072739')
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 ('2072738', '2072739')
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.
N219SB155 Aviation LLC · Redwood City, CAN2200FQualitair LLC Trustee · MichelstadtN2209HLynxaviation LLC · Carpinteria, CAN221GSBarientos Bryan I · Petaluma, CAN2221XK C Leasing Corp · Woods Cross, UTN2228THulsey Hunter · Madison, MSN222KWHines Tommy · Calvert City, KYN2234UMountain States Casing Co LLC · Timnath, CON2237SOregon State Police · Salem, ORN223JMEid Bradley · Greenwood, INN2244WTextron Aviation Inc · Wichita, KSN224TFCdtskyview LLC · Medford, ORN2252ZBerman Rayanne S · Hatfield, PAN2265WStratus Aviation LLC · Fergus Falls, MNN2266KFelix Ken Allen · Rye, CON226JWThompson Edward Allen · Sunset Beach, NCN226TMWadeberg LLC · San Francisco, CAN2270GNorris Edgar L Jr · Charlotte, NCN2270QSure Aviation LLC · North East, MDN22761Kop Aviation LLC · El Paso, TXN2278YWplanec LLC · Gig Harbor, WAN227WFTrayler James · Waco, TXN228AZCiaglia Caesar Earle · Mokena, ILN2291SRegistered aircraftN22952Winging It LLC · Lindon, UTN2297VTicknor Robert James · Adel, IAN22CUGbh Aviation · Santa Monica, CAN2318LButerbaugh Richard A · Summerville, SCN232JMWillfish LLC · Mentor, OHN233TSLittle Sunflower LLC · Bridgewater, CTN234MFGone Flying LLC · Salt Lake City, UTN2355PDice Jeremy L · Redmond, ORN23563Aircraft Leasing And Sales LLC · Riviera Beach, FLN237REDobbert Thomas · Reno, NVN238CSD H Hutson Enterprises Inc · Waxhaw, NCN238MChe Brothers LLC · Winters, CAN23VGPainted Horse Holding LLC · New Town, NDN24129Ssi Aviation Group LLC · Eagle, IDN2413M2021 Liberty Air LLC · Santa Rosa, CAN241KRMako Offshore Exploration Inc · Pagosa Springs, CON2423CGriffin Aviation LLC · Ventura, CAFirst renewal noticeN24240Vantage Asset Management LLC · Edinburg, TXN2424PMize Craig · Cerulean, KYN2426BDBA Investments LLC · Eldon, MON2427BKbtp Holdings LLC · Sewickley, PAN24289Collen Rodney J · Tacoma, WAN2428JWilliams Shirley A Trustee · Alpine, TXN2429QKaufer Peter H · Tucson, AZN2431XDvirnak Paul · Hesperus, CON2433UEddleman David Baggett · Mclean, VA
Back to Cessna T182T