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 ('2072434')
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 ('2072434')
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.
N545DSAero Maintenance Inc · Vancouver, WAN5463JMachado Joe L · Tucson, AZN5464DJprg Aviation Inc · Orlando, FLN5466D5466 Delta LLC · Costa Mesa, CAFirst renewal noticeN5473DN1705r Inc · Cobb, CAN5479DSpanaflight LLC · Puyallup, WAN5480EColgan Aviation LLC · La Crosse, WIN5484DAerobiz LLC · Lewes, DEN5486DFord Bernard DBA · Sidney, NYN5488DCardoso Roberto Y · Montclair, CAN5495DSorbi Aviation Inc · El Cajon, CAN54KHHertenstein Kevin Wayne · Lutz, FLN5509JJet Air Inc · Iowa City, IAN5512EMorcom Aviation Services Inc DBA · Everett, WAN5519JGoodwyn Thomas M · Las Vegas, NVN551PGChavi LLC · Fredericksburg, TXN5520DSwaeringen Eric · Snohomish, WAN5534ELindsey Kelly M · Throckmorton, TXN5536EJeffries And Hendley LLC · Greenwood, INN5543EMedina Kevin S · Glendale, CAN5546JRegistration Pending · Danbury, CTRegistration pendingN5550JOptima Aviation LLC DBA · Lewisville, TXN5552EAbove And Beyond Aviation LLC · Austin, TXN555LASouth Latitude Aviation Service LLC · Humble, TXN555ZHWurth Gary P · Rochester, NYN5595EV & E Sunset LLC · St George, UTN5597ECtj Flyers LLC · Bowdon, GAN55HAHonaker Group LLC · Sellersburg, INN55QBSainthill Raymond C · Long Beach, NYN55YPBmf Jax LLC · Jacksonville, FLN5605JMajor Air LLC · Charleston, SCN5616EDhl Skyhawk Inc · Martinez, CAN5617JSale Reported · Wilton, CASale reportedN5619ELiberty Flying Service LLC · Castroville, TXN5623EKd3262 LLC · Downers Grove, ILN5623GMorris Hancock Flying Club · Morris, MNN5624GFoothill Aircraft Sales & Service · Upland, CAN5631EN141ns LLC · Lantana, FLN5635ECircle W Flying Club Inc · Creighton, PAN5640EHunt Jacky R · Bowling Green, KYN5649GMaran Properties LLC · Lowell, ARN5652ECgumps LLC · Antioch, TNN5656EN2893e LLC · Reno, NVN566BGN566bg LLC · Leesburg, VAN566QButte Aviation Inc · Butte, MTN5697ERedstone Arsenal Flying Activity · Redstone Arsenal, ALN56EPSanders Flight Training Center Inc · Jasper, ALN56FASilver Express Co DBA · Miami, FLN56LJL & J Aviation Inc · Atwater, CAN5700ERegistration Pending · Fort Lauderdale, FLRegistration pending
Back to Cessna 172N