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.
N413TCMcbeath Casey A · Shreveport, LAN421KRAerospace Trust Management LLC Trustee · Wilmington, DEN423TABas Part Sales LLC · Greeley, CON424EKDeland Air And Sea Brokerage Inc · Deland, FLN424WHSchmidt Richard A · West Linn, ORN427AMState Of Oregon · Salem, ORN427APTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN432BPLaporte Enterprises LLC · Midland, TXN432EAVanderloop Equipment Inc · Brillion, WIN43TRMeichelle Enterprises Inc · Santa Barbara, CAN452PDBpd Enterprises LLC · Ponte Vedra Beach, FLN458MGFlywheel LLC · Charleston, WVN459AJBoren Perry P · Arley, ALN477LPTomchan LLC · Bostic, NCN478FGHazelbaker Tara L · Loxley, ALN47KMMyers Boyz Aviation LLC · Horseshoe Bay, TXN481TCFargo Aviators LLC · Phoenix, AZN481WPoper Jeremy · Albuquerque, NMN482CGKilo Sierra Enterprises LLC · Lafayette, CON4839TOrchard Elms LLC · North Ogden, UTN484HRCebolla Air LLC · Camarillo, CAN4855PAvenger Aviation LLC · Midland, TXN492TBTrux Aviation LLC · Wilmington, DEN495JBVan Bortel Aircraft Inc · Arlington, TXN496VBerkenkotter Transportation LLC · Howard, CON5015HKnox Fred · Los Altos, CAN5020ABrown Jonathan Corey · Sherman Oaks, CAN5033TJulol Investments LLC · Miami, FLN50588Registered aircraftN5061CMatheny Robert Gregg · Kingman, AZN5066HDohr William F · Williamsburg, VAN508ACKtaz Air LLC · Niceville, FLN50VVVictor Victor Leasing LLC · Pompton Plains, NJN5107YBrown Peter B · Salem, VAN512DPCanal Aviation LLC · Dover, DEN5134BSalinas Four LLC · Salinas, CAN5139WConnelly James · Spearman, TXN513KMFreedom N513km LLC · Pacific City, ORN513VMMccabes Supply Inc · Watertown, NYN5143QMelnyk George · Sheridan, ORN5148YIe3 Enterprise LLC · Elk Grove, CAN514DGSilver Surfer Enterprises LLC · Hot Springs, ARN5153GHeath Sean · Valley Center, CAN5156MRojas Jose Luis Gomez · Thermal, CAN515DPBell Denise Augusta · Orlando, FLN5160YArnett Randall C · Anchorage, AKN5164UElias Maria · El Paso, TXN5164XBlr Flyers LLC · Missoula, MTN51651Terry Robert · Billings, MTN5166HKeltz Brandon E · Montrose, CO
Back to Cessna T182T