Skip to content

Registered aircraft · 1,446

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 ('2071826')
  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 ('2071826')
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.

N19451Allison Jeremy L · Chandler, AZBuilt 1973 · S/N 15074427 N19453Top Flight LLC · Wilmington, DES/N 15074429 N19463Aviation Trust Co LLC · Oklahoma City, OKBuilt 1973 · S/N 15074431 N19469Registration Pending · Summerland Key, FLRegistration pendingS/N 15074433 N19476Havron Dana Houston · Huntsville, ALS/N 15074438 N19477Rare Birds LLC · Yukon, OKBuilt 1973 · S/N 15074439 N19479Kunkle Bryan S · Mount Morris, NYBuilt 1973 · S/N 15074441 N19480Blair Mark · Kingman, AZBuilt 1973 · S/N 15074442 N19481Majors Flying Club · Greenville, TXBuilt 1973 · S/N 15074443 N19486Beavers David Allen · Strasburg, COS/N 15074444 N194961w1 Aero LLC · Issaquah, WABuilt 1973 · S/N 15074450 N19506Colvard Tony D · Newland, NCS/N 15074457 N19508Andelt David L · Parker, COBuilt 1973 · S/N 15074459 N19514N&C Enterprises LLC · Vine Grove, KYS/N 15074461 N19516Choppin Dale · Sun City, AZBuilt 1973 · S/N 15074462 N19520Ag Avventures LLC · Hartford, WIS/N 15074465 N19522Cannan Aviation Inc · Georgetown, TXS/N 15074467 N19523Frana Joel A DBA · Fort Myers, FLBuilt 1973 · S/N 15074468 N19524Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1973 · S/N 15074469 N19526Soebagyo Vincent · Hollywood, CABuilt 1973 · S/N 15074471 N19531Archer Collins Etheridge · Fairview, TXBuilt 1973 · S/N 15074476 N19534Smith Paul C Sr · Winthrop, MES/N 15074479 N19550Cheap Flight Time LLC · Athens, GAFirst renewal noticeBuilt 1973 · S/N 15074480 N19558Moon Jonathan E · Butler, PABuilt 1973 · S/N 15074485 N19564Priewe Jeff C · Como, MSBuilt 1973 · S/N 15074489 N19568June Richard · Stevenson Ranch, CABuilt 1973 · S/N 15074492 N19572Borzoya Aero Group Inc · Slatington, PABuilt 1973 · S/N 15074496 N19582Olson Ben A · Gig Harbor, WABuilt 1973 · S/N 15074505 N19587Steward Matthew C A · Broken Arrow, OKBuilt 1973 · S/N 15074509 N19588Kenner David · Maddock, NDS/N 15074510 N19589Eaton William I Jr · Seabrook, NHBuilt 1973 · S/N 15074511 N19590Koskan John M · Wood, SDBuilt 1973 · S/N 15074512 N19592Aviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1973 · S/N 15074514 N19594Jeter Ray E · Spring Hill, FLS/N 15074516 N19597Estrada Katrina · Helotes, TXBuilt 1973 · S/N 15074519 N197KSOld Goat LLC · Wilmington, DEBuilt 1971 · S/N 15072697 N1NSEagle Equity Inc · Valparaiso, INBuilt 1973 · S/N 15074284 N1TLLewis Thomas A · Roanoke, VABuilt 1974 · S/N 15075710 N21900Odonnell Edward T · Waconia, MNBuilt 1973 · S/N 15074521 N21902Sleeping Giant Flying Club Inc · Helena, MTBuilt 1973 · S/N 15074523 N21904Ragsdale Justin S · Bartlett, TNBuilt 1973 · S/N 15074525 N21908Harrison Robert W · Oak Harbor, WAS/N 15074528 N21917Kinser Jay · Monrovia, MDS/N 15074534 N21919Gustafson Dean F · Mercer, WIBuilt 1973 · S/N 15074536 N21923Averett Jeremy J · Liberty, UTS/N 15074540 N21924Berwick Mark A · Emmett, IDBuilt 1973 · S/N 15074541 N21929Holland Roy Morgan · Santa Maria, CABuilt 1973 · S/N 15074544 N21930Bonnett Paul R · Pine Valley, CABuilt 1973 · S/N 15074545 N21936Kempf Ian J · Havana, ILS/N 15074551 N21938Harrigan Kevin T · Nova, OHBuilt 1973 · S/N 15074553

Back to Cessna 150L