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.
N52241Christiansen Aviation LLC · Wilmington, DEN5224EFlight Training Aircraft LLC · Wilmington, DEN5224GBank Of Utah Trustee · Salt Lake City, UTN52262Skymates Inc · Wilmington, DEN5226DFargo Jet Center LLC · Fargo, NDN522NDSpartan Education LLC · Tulsa, OKN523ABVector Air LLC · Erie, CON523ERBagamaspad Alan M · Reseda, CAN523NDSunrise Aviation Inc · Ormond Beach, FLN524NDPhoenix East Aviation LLC · Daytona Beach, FLN52519Northwestern Michigan College · Traverse City, MIN5251ZMustang Sally Aviation LLC · Camden, SCN52522Mustang Sally Aviation LLC · Camden, SCN5252JNorthwestern Michigan College · Traverse City, MIN52531Csa Aircraft Leasing LLC · Salt Lake City, UTN52535Voroshuck Clayton T · Sunnyvale, CAN5253CMustang Sally Aviation LLC · Camden, SCN5253XMaranatha Insurance Service Inc · Rancho Cucamonga, CAN5254QRocky Mountain Flight Consultants LLC · Boulder, CON5254WGlacier Peak Aviation LLC · Carnation, WAN5255RZin Services LLC · Dover, DEN5256SFargo Jet Center LLC · Fargo, NDN5258YChristiansen Aviation LLC · Wilmington, DEN525NDAerosim Academy Inc · Sanford, FLN52606Cirrus Aviation Inc · Sarasota, FLN5262UL&W Aircraft Investment LLC · Homestead, FLN5262YLead Turn Aviation LLC · Ogden, UTN5267RCastlegate Corp · Monee, ILFirst renewal noticeN5267YCkb Management LLC · Fayetteville, ARN5269NHigh Maintenance Inc · San Luis Obispo, CAN526ERLong Island Aviators LLC · Seaford, NYN526NDSpartan Education LLC · Tulsa, OKN5270GLewis University · Romeoville, ILN52712Macmillan Elizabeth A · Franklin, MAN5272NMaddie LLC · Hinton, WVN5273UKatola LLC · Anaheim, CAN5274VH & R Aviation LLC · West Linn, ORN5275S75s Leasing LLC · Greenwood Village, CON5275WMustang Sally Aviation LLC · Camden, SCN5276PBellers Aviation Inc · Fremont, CAN52794Hawk Flyer 794 LLC · San Bruno, CAN527DSSkyhawk Leasing LLC · Greenfield, INN527NDPhoenix East Aviation LLC · Daytona Beach, FLN5280DHdw Florida Helicopters Inc · Pompano Beach, FLN5280RSpringbrook Leasing LLC · Daytona Beach, FLN5284SFly America Inc · Stanford, CAN52858Channel Islands Aviation Inc · Camarillo, CAN5286CUnited Flying Club Inc · Belmont, CAN5288TG & S Air Adventures LLC · Jersey City, NJN528ERMary Air LLC · White Rock, NM
Back to Cessna 172S