Skip to content

Registered aircraft · 857

Aircraft of this model in the FAA registry, by N-number.

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 ('2072432')
  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 ('2072432')
ORDER BY n_number

Run 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.

N7040QOrlandi Properties LLC · Blairstown, NJBuilt 1971 · S/N 17260340 N7041QElizabeth City State University · Elizabeth City, NCBuilt 1971 · S/N 17260341 N7042QWatts Ruiz LLC · Waco, TXBuilt 1971 · S/N 17260342 N7043QNelson Christopher J · Hayfield, MNBuilt 1971 · S/N 17260343 N7048QFirelight Academy LLC · Brush, COBuilt 1972 · S/N 17260348 N7049QVortex Aero LLC · Lakeland, FLBuilt 1972 · S/N 17260349 N7050QMindy Limited LLC · Muscatine, IABuilt 1972 · S/N 17260350 N7051QBright Flight Aviation Inc · Jacksonville, FLBuilt 1972 · S/N 17260351 N7052QHoloman T Michael · New Smyrna Beach, FLBuilt 1972 · S/N 17260352 N7053QCabrie Aviation Inc · Charlotte, NCBuilt 1972 · S/N 17260353 N7055QSeagraves Brad J · Rockwell, NCBuilt 1972 · S/N 17260355 N7056QFleeman Joseph R · Lawrenceburg, TNBuilt 1972 · S/N 17260356 N7057QMindy Limited LLC · Muscatine, IAS/N 17260357 N7060QPilot In Command Academy Inc · Miami, FLBuilt 1972 · S/N 17260360 N7061QMccutcheon Henry C · Frankfort, KYBuilt 1972 · S/N 17260361 N7063QCarver Clarence K · Lutz, FLS/N 17260363 N7068QWestwind Aviation Inc · Bremerton, WABuilt 1972 · S/N 17260368 N7069QFlakker Michael E · Gold Hill, NCS/N 17260369 N7071QSun Country Aero Club · The Villages, FLS/N 17260371 N7072QB&R Aircraft LLC · Wadsworth, OHS/N 17260372 N7075QCorell Ryan J · Mason City, IAS/N 17260375 N7076QAbbott Brett C · Leawood, KSBuilt 1972 · S/N 17260376 N7080QFerraro Paul · Seattle, WABuilt 1972 · S/N 17260380 N7082QAmerican Patrols Inc · Midland, TXBuilt 1972 · S/N 17260382 N7083QSevensixzerozero LLC · Boerne, TXBuilt 1972 · S/N 17260383 N7084QMarcks Jason M · Shiocton, WIFirst renewal noticeS/N 17260384 N7094QRegistered aircraftBuilt 1972 · S/N 17260394 N7095QWong Henry L III · Lake Forest, CABuilt 1972 · S/N 17260395 N7099QVenaleck John T · Painesville, OHBuilt 1972 · S/N 17260399 N7102QJuckett Jimmy L · Springhill, LABuilt 1972 · S/N 17260402 N7108QAnderson Michael · Hillsboro, NDBuilt 1972 · S/N 17260408 N7109QLawless Bruce A · Lago Vista, TXBuilt 1972 · S/N 17260409 N7110QLawson Virgil · Sylvar Grove, KSS/N 17260410 N7113QMiles Michael G · Hillsborough, NCBuilt 1972 · S/N 17260413 N7114QSass Kenneth · Charlotte, NCBuilt 1972 · S/N 17260414 N7115QMaggart Kenneth R · Lutz, FLBuilt 1972 · S/N 17260415 N7116QStogner Sarah E · Monahans, TXBuilt 1972 · S/N 17260416 N7118QMartin Stephen T · Green Cove Springs, FLBuilt 1972 · S/N 17260418 N7120QClodfelter Terry Lynn · Norwood, NCBuilt 1972 · S/N 17260420 N7124QVy Aviation LLC · Gentry, ARBuilt 1972 · S/N 17260424 N7125QPiedmont Flight Inc · Winston Salem, NCBuilt 1972 · S/N 17260425 N7128QAmerican Patrols Inc · Midland, TXBuilt 1972 · S/N 17260428 N7129QG Alaouie LLC · Port Austin, MIBuilt 1972 · S/N 17260429 N7132QAero Quest LLC · Olive Branch, MSBuilt 1972 · S/N 17260432 N7133QPage Aerial Service Inc · Rochelle, ILBuilt 1972 · S/N 17260433 N7135QHoman Larry E · Sigourney, IABuilt 1972 · S/N 17260435 N7136QPa Lawrence LLC · Anchorage, AKBuilt 1972 · S/N 17260436 N7139QFernander David · Enterprise, ALBuilt 1972 · S/N 17260439 N7140QMagnuson Jessica M · Olathe, KSBuilt 1972 · S/N 17260440 N7141QFlight Time Builders Inc · Memphis, TNBuilt 1972 · S/N 17260441

Back to Cessna 172L