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 ('2071826')
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 ('2071826')
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.
N1780QDabone Salim · Dell City, TXN1784QRed Cardinal Aviation LLC · Chantilly, VAN1787QHancock Aviation LLC · Baton Rouge, LAN1788QElgamil Noureldin M · West New York, NJN1791QNearpass Stephen J · Seneca Falls, NYN1793QFreedom Aviation Inc · Lynchburg, VAN179DBBrisco Daniel J · Fort Myers, FLN18004Hause James H · Negley, OHN18006Lockhart Curtis M · Bay Village, OHN18015Little Bird 150 LLC · Lake Tapps, WAN18020N18020 LLC · Chandler, AZN18021Tilden Jeffrey D · Columbus, INN18023Remain In The Pattern LLC · Meridian, IDN18025Evans II Rodney D · Saint Albans, WVN18032Old School Aircraft LLC · Jackson, TNN18033Barkley John · Austin, TXN18042Carey Daniel F · Rockville Centre, NYN18046Beavers David A · Strasburg, CON18050Jarrell Loyd F · Whitesburg, TNN18052Sky Views LLC · Mount Crawford, VAN18057Palmer Jedidiah J · Lewiston, IDN18061Foster Rodney D · Quanah, TXN18067Get Out Aviation LLC · Palmer, AKN18069Olandese Donald J · Newalla, OKN18071Rock River Aviation · Watertown, WIN18076Angelos Mark A · Concord, CAN18081Eyes Above LLC · Hampton Falls, NHN18088Durin Steven C · Steward, ILN18100Liberty University School Of Aeronautics · Lynchburg, VAN18104Toth Stephen K · Northampton, PAN18109Szoke Elliott · Mukilteo, WAN18110Radke Steven H · Hastings, MNN18115Hinds Community College · Raymond, MSN18126Harroun Charles G · Maryville, MON18140Johnroe Ryan M · Mount Pleasant, MIN18144Kachemak Bay Flying Service · Temple, TXN18145Stlouis Aviation LLC · Miramar, FLN18155Willis Nathan Eric · Broken Arrow, OKN18157Matz Robert D · Niles, MIN18162Pruzek Richard L · Chippewa Falls, WIN18163Wings Aero LLC · Zeeland, MIN18164Cendejas Agustin · Chino, CAN18167Be Chara Niz Ar E · Columbia, MDN18171Isaacson Arthur T · Hillsboro, MON18173Bb Aero Works Ltd · Whitehouse, OHN18177Hoffman Rick W · Elk River, MNN18180Woodward Aviation · Varnville, SCN18189Jaam-A LLC · Matthews, NCN18197C150 Holdings LLC · Newark, DEN18198Ohare Douglas K · Ainsworth, NE
Back to Cessna 150L