Skip to content

Registered aircraft · 260

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

N4478UGlaze Jess J · Chandler, AZBuilt 1964 · S/N 15060478 N4484UCox Walter W · Hale Center, TXBuilt 1964 · S/N 15060484 N4485UMapes Peter B · Oscoda, MIBuilt 1964 · S/N 15060485 N4486UTaylor Roger D · Paris, TNBuilt 1964 · S/N 15060486 N4489U237th Aero Squadron Inc · North St Paul, MNBuilt 1964 · S/N 15060489 N4496UMcgraw David M · Fairbanks, AKBuilt 1964 · S/N 15060496 N4498UN4498u LLC · Langley, WABuilt 1964 · S/N 15060498 N4499UMcmahon John P · Huntington Beach, CABuilt 1964 · S/N 15060499 N4500UButler Dale K · Hillsborough, NCBuilt 1964 · S/N 15060500 N4501UPruzek Russell T · New Auburn, WIBuilt 1964 · S/N 15060501 N4502UWise Joseph D · Kilgore, TXBuilt 1964 · S/N 15060502 N4505UYates Kenneth E · Meridian, MSBuilt 1964 · S/N 15060505 N4506UBryson James D · Casstown, OHBuilt 1964 · S/N 15060506 N4510UOrsak Chris L · Seymour, TXBuilt 1964 · S/N 15060510 N4516USteelman Aviation LLC · Montague, CAS/N 15060516 N4521URodriguez Sergio · Rancho Cucamonga, CAS/N 15060521 N4524UJennett Chris · Hudson, FLBuilt 1964 · S/N 15060524 N4526UDrewelow Kevin R · Topeka, KSBuilt 1964 · S/N 15060526 N4527UToth Karl A · Fair Oaks, CABuilt 1964 · S/N 15060527 N4530UWorthington Gary · Swifton, ARBuilt 1964 · S/N 15060530 N4546UHarrier Soaring Club Inc · Raleigh, NCBuilt 1964 · S/N 15060546 N4547URegistered aircraftN-number assigned, not yet registeredS/N 15060547 N4548UHaan James J · Norton Shores, MIS/N 15060548 N4549UJmh Futures LLC · Gilbert, AZS/N 15060549 N4550UGreene County Holdings LLC · Albany, NYBuilt 1964 · S/N 15060550 N4553UCoyle Jonathan D · Franktown, COBuilt 1964 · S/N 15060553 N4557UCrum Thomas A · Loyal, OKBuilt 1964 · S/N 15060557 N4559UBoyd Jeffrey S · Hutsonville, ILBuilt 1964 · S/N 15060559 N4563UBailey Wesley S · Bulverde, TXBuilt 1964 · S/N 15060563 N4566UGruver Norval T · Bartlesville, OKBuilt 1964 · S/N 15060566 N4567UWaits Kerry S · Red Bluff, CAS/N 15060567 N4571UMcguffee James Darron · Columbia, LABuilt 1964 · S/N 15060571 N4573UMulder Timothy D · Shafter, CAS/N 15060573 N4574UAirmotive Service LLC · Brigham City, UTBuilt 1964 · S/N 15060574 N4579USquiers Frederick Eugene · Barre, VTS/N 15060579 N457GGBohl Howard M · Temecula, CAS/N 15060269 N4580UDean Nolan W · Harrisonburg, VABuilt 1964 · S/N 15060580 N4584UDavis Jubal L · Waverly, OHBuilt 1964 · S/N 15060584 N4586UCate Randall L · Knoxville, TNBuilt 1964 · S/N 15060586 N4591UJacobsen Ian M · Lincoln City, ORBuilt 1964 · S/N 15060591 N4594UMclendon Michael L · Whitesboro, TXBuilt 1964 · S/N 15060594 N530RCLoizides Louis N · Safety Harbor, FLBuilt 1963 · S/N 15060171 N5901TWilliams Terry A · Hazlehurst, GABuilt 1964 · S/N 15060601 N5905TThomas Paul C · Roberts, WIBuilt 1964 · S/N 15060605 N5906TGraf John R · Mather, CABuilt 1964 · S/N 15060606 N5907TMccracken David M · Woodland, PABuilt 1964 · S/N 15060607 N5908TDorweiler Tom O · Springfield, MOBuilt 1964 · S/N 15060608 N5918T2400 Rickenbacker LLC · Auburn, CABuilt 1964 · S/N 15060618 N5920TLowe David M · Sacramento, KYBuilt 1964 · S/N 15060620 N5922THamilton David A · Piedmont, OHS/N 15060622

Back to Cessna 150D