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.
N860SPRegistered aircraftN860TWSun City Air Charter LLC · Davie, FLN863PAUniversity Of Alaska Anchorage · Anchorage, AKN863SPLegacy Aviation LLC · Tea, SDN864CKTabatabai Seyed Ali · Houston, TXN864SPAmeriflyers Of Texas Inc · Addison, TXFirst renewal noticeN865CKAero American Flight LLC · Houston, TXN865PAPlatinum Angel LLC · Melbourne, FLN867CPCivil Air Patrol · Maxwell Afb, ALN867LAHillsboro Aero Academy LLC · Hillsboro, ORN868SPWestbank Fishing LLC · Kiln, MSN868TBSo Cal Leasing LLC · El Cajon, CAN869FGMustang Sally Aviation LLC · Camden, SCN870SPEstern Kentucky University · Richmond, KYN872SPChristiansen Aviation LLC · Wilmington, DEN873EFFlorida Flight Training Center · Venice, FLN878SATampa Bay Aviation Inc · Clearwater, FLN879LPSpartan National Holdings LLC · Missoula, MTN87HFHeritage Asset Leasing LLC · Ronkonkoma, NYN87JAN87ja Lk Aircraft Holdings LLC · Wheeling, ILN881ACFly Twin Comanche LLC · Peoria, AZN882TCChristiansen Aviation LLC · Wilmington, DEN884BCBusiness Mens Flying Club Inc · Naperville, ILN885GTYellow Jacket Flying Club Inc · Atlanta, GAN888LUFourth Stoop Flyers LLC · Manakin Sabot, VAN889SPLeading Edge Aviation Inc · Spencer, IAN88JAGc Aviation Services-1 LLC · Miamisburg, OHN894KCFlight Training Aircraft LLC · Wilmington, DEN897LPMarcus Air LLC · Plano, TXN9004WMustang Sally Aviation LLC · Camden, SCN901CPCivil Air Patrol Inc · Maxwell Afb, ALN9027CElizabeth City State University · Elizabeth City, NCN903CPCivil Air Patrol Inc · Maxwell Afb, ALN90404Liberty University · Lynchburg, VAN9045BEhg Flight LLC · Venice, CAN904CPAbove And Beyond Aviation LLC · Austin, TXN904DRSo Cal Leasing LLC · El Cajon, CAN90508Liberty University · Lynchburg, VAN905CPCivil Air Patrol Inc · Maxwell Afb, ALN906CPCivil Air Patrol · Maxwell Afb, ALN906JRAmeriflyers Of Texas Inc · Addison, TXN907CPCivil Air Patrol Inc · Maxwell Afb, ALN907JWPalm Beach Flight Training Corp · Lantana, FLN907LPMicro Publishing Press Inc · Truckee, CAN908CPCivil Air Patrol Inc · Maxwell Afb, ALN9096ZChristianen Aviation LLC · Wilmington, DEN909CPCivil Air Patrol · Maxwell Afb, ALN909EDEdwards Aero Club · Edwards Afb, CAN909KSKingsky Flight Academy LLC · Lakeland, FLN90SUOhio State University · Columbus, OH
Back to Cessna 172S