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.
N6869TCsa Aircraft Leasing LLC · Salt Lake City, UTN686SPRainier Flight Service LLC · Renton, WAN687BASvetfur Aviation LLC · Camden, SCN687SPBmg Aviation Inc · Bloomington, INN688AAAoa Kissimmee Inc · Kissimmee, FLN691SPGc Aviation Services-1 LLC · Miamisburg, OHN691TCSpartan National Holdings LLC · Missoula, MTN692CPCivil Air Patrol · Maxwell Afb, ALN692SPSmith Holdings Inc · Wilmington, DEN693SACaddo Aircraft LLC · Lewes, DEN694CPCivil Air Patrol · Maxwell Afb, ALN694SPFox Leasing Group LLC · Hollywood, FLN695SPJet Air Inc · Iowa City, IAN697CPCivil Air Patrol · Maxwell Afb, ALN698JABon Bon Aviation LLC · Daly City, CAN698SPFoothill Aircraaft Sales & Service Inc · Upland, CAN699LPFrg III Inc DBA · Lincoln Park, NJN700PMRar LLC · Louisville, KYN701LULiberty University · Lynchburg, VAN701SPScandinavian Aviation Academy Inc · El Cajon, CAFirst renewal noticeN702LULiberty University · Lynchburg, VAN703LULiberty University · Lynchburg, VAN704LULiberty University · Lynchburg, VAN704RBAirway Equipment Leasing LLC · Alpharetta, GAN705JAFrl Flying LLC · Seattle, WAN705LULiberty University · Lynchburg, VAN706LULiberty University · Lynchburg, VAN707LULiberty University · Lynchburg, VAN707PDTfs Air LLC · Loveland, CON708LULiberty University · Lynchburg, VAN709LULiberty University School Of Aeronautics · Lynchburg, VAN710LULiberty University School Of Aeronautics · Lynchburg, VAN710SPElite Approach LLC · Chesterfield, MON711JSSterling Flight Training · Jacksonville, FLN712NVEpic Aviation Enterprises LLC · Austin, TXN712SPAmeriflyers Of Texas Inc · Addison, TXN713RBKay Timothy A · Kyle, TXN714HWNational Training 1 LLC · Wilmington, DEN715MTSaz Dynamics LLC · Daly City, CAN716LULiberty University · Lynchburg, VAN716SPExec 1 Aviation II LLC · Ankeny, IAN71HFHeritage Asset Leasing LLC · Ronkonkoma, NYN71HTAerodynamic LLC · Aurora, ORN720CPCivil Air Patrol · Maxwell Afb, ALN721CTChristiansen Aviation LLC · Wilmington, DEN721LULiberty University · Lynchburg, VAN722MAK2 Aviation LLC · Greenwood Village, CON723SPElite Approach LLC · Chesterfield, MON724SPCandace A Larned Enterprises Inc · Long Beach, CAN725PGPoplar Grove Airmotive Inc · Poplar Grove, IL
Back to Cessna 172S