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 ('2072439', '2072442')
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 ('2072439', '2072442')
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.
N62199Aircraft Guaranty Corp Trustee · Oklahoma City, OKN621PMAtp Aircraft 1 LLC · Wilmington, DEN621TCsa Aircraft Leasing LLC · Salt Lake City, UTN62245Gabrieles Wings LLC · Oldwick, NJN6228NGreenwich Venture Partners LLC · Greenwich, CTN6229QChristiansen Aviation LLC · Wilmington, DEN622CMMcgill Charles · Sunriver, ORN6238AExecutive Flight Institute LLC · Murrieta, CAN623KWLanier Equipment Leasing LLC · Gainesville, GAN623SPAtp Aircraft 2 LLC · Wilmington, DEN6242FAzul Services LLC · Bozeman, MTN6245BInternational Air Services Inc Trustee · Carson City, NVN6245CWings Over Texas Holdings LLC · Denton, TXN6245EDirty Side Down Aviation LLC · Georgetown, TXN625SPSilverhawk Aviation Academy LLC · Caldwell, IDN6265TW Air LLC · Wheeling, ILN6269QMustang Sally Aviation LLC · Camden, SCN626CBWings Over Texas Holdings LLC · Denton, TXN62770Hog Island Flying LLC · Winter Park, FLN627SPFxe Flightcenter Corp · Fort Lauderdale, FLN62875L&W Leasing LLC · Smyrna, TNN629AHSuburban Air Corp · Castro Valley, CAN629BCVolar V LLC · Edmond, OKN630HRMiga Holdings LLC · Flower Mound, TXN63177Christiansen Aviation LLC · Wilmington, DEN6317GChristiansen Aviation LLC · Wilmington, DEN631CTCoast Flight Training And Management Inc · San Diego, CAN63251Christiansen Aviation LLC · Wilmington, DEN632CRChristiansen Aviation LLC · Wilmington, DEN632SPWestosha Flying Club Inc · Kenosha, WIN63371Flight Training Aircraft LLC · Wilmington, DEN6337XUnique Educational Experiences Inc · Long Beach, CAN6338DEdb Air Inc · Wilsonville, ORN633CRChristiansen Aviation LLC · Wilmington, DEN633NDAyah Investments LLC · Kent, WAN63405Christiansen Aviation LLC · Wilmington, DEN6341TGoose Leasing LLC · Ashburn, VAN6342BFargo Jet Center LLC · Fargo, NDN6342XRainier Flight Service LLC · Renton, WAN634CRChristiansen Aviation LLC · Wilmington, DEN634GLVolar Xi LLC · Edmond, OKN634SJAmeriflyers Of Texas Inc · Addison, TXN635BASvetfur Aviation LLC · Camden, SCN635BKGuilford County · Greensboro, NCN635CRChristiansen Aviation LLC · Wilmington, DEN635NDEveryday Airman LLC · Seattle, WAN635SPAtp Aircraft 2 LLC · Wilmington, DEN636CRChristiansen Aviation LLC · Wilmington, DEN636SAMustang Sally Aviation LLC · Camden, SCN637CRChristiansen Aviation LLC · Wilmington, DE
Back to Cessna 172S