Skip to content

Registered aircraft · 1,439

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

N6031KMajor Ryan S · San Angelo, TXBuilt 1975 · S/N 15077483 N6039KMejia Soto Luis I · Plainfield, CTS/N 15077489 N6040KReyna Zachary · Windcrest, TXS/N 15077490 N6046KAl-Rubaiie Haider A · Fort Worth, TXBuilt 1975 · S/N 15077494 N6052KCollins Robert E · Belleville, ILBuilt 1975 · S/N 15077496 N6065KMiller Durwood B · Screven, GABuilt 1975 · S/N 15077505 N606JCAsencio Garcia Enrique R · Fort Worth, TXBuilt 1976 · S/N 15078753 N6071KBlumhagen Myron M · Drake, NDBuilt 1975 · S/N 15077509 N6077KRocha Adrian M · Rosharon, TXBuilt 1975 · S/N 15077513 N6082KCarlton David L · Galesburg, ILBuilt 1975 · S/N 15077516 N6094KPcs Aviation LLC · Louisa, VAFirst renewal noticeBuilt 1975 · S/N 15077522 N6109KRiegel Frederick E · Houston, OHBuilt 1975 · S/N 15077530 N6112KNordby Tyler D · Herman, MNBuilt 1975 · S/N 15077532 N611JFKeller Robert W · Racine, WIS/N 15077427 N6120KArico James A · Lisbon, CTBuilt 1975 · S/N 15077535 N6122KKidd Robert Lee · Logan, UTBuilt 1975 · S/N 15077536 N6129KLatrobe Aviation Enterprises LLC · Youngstown, PABuilt 1975 · S/N 15077538 N6133KSturguess James K · Boonville, MOS/N 15077542 N6134KMackenzie Stuart · Pearland, TXS/N 15077543 N6139KKuykendall Justin R · Petaluma, CAFirst renewal noticeBuilt 1975 · S/N 15077547 N6142KCreamer Ryan Patrick · Tower Hill, ILBuilt 1975 · S/N 15077550 N6151KRomano Aviation LLC · Barrington, RIBuilt 1975 · S/N 15077555 N6161KSmith William F · Hindsville, ARBuilt 1975 · S/N 15077562 N6163KJennings Steven W · Austin, TXS/N 15077563 N6176KDeal Clarence · Jonesboro, GABuilt 1975 · S/N 15077571 N6177KMoses Annie R · Uvalde, TXBuilt 1975 · S/N 15077572 N6180KHutton Stephen · Madison, MSBuilt 1975 · S/N 15077573 N6185KLa Porta John R · Des Moines, WABuilt 1975 · S/N 15077576 N6186KSopalsky John J · Goshen, NYBuilt 1975 · S/N 15077577 N6188KLanning 2 Aviation LLC · Amarillo, TXBuilt 1975 · S/N 15077578 N6198KPoland Charles Fallon Pennock · Humacao, PRBuilt 1975 · S/N 15077583 N6207KMoberg Charles W · Edina, MNBuilt 1975 · S/N 15077587 N6211KCalifornia Management And Consulting LLC · North Hollywood, CABuilt 1975 · S/N 15077588 N6214KHamptonville Aviation LLC · Hamptonville, NCBuilt 1975 · S/N 15077590 N6217KIoannou Yiannakis C · Wilmington, NCBuilt 1975 · S/N 15077593 N6219KIrwin Michael C · North Fort Myers, FLBuilt 1975 · S/N 15077594 N6220KKasden Louis Jr · San Diego, CABuilt 1975 · S/N 15077595 N6221KWilson Steven J · Elkton, KYS/N 15077596 N6226KBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 1975 · S/N 15077599 N6227KBuchman Jeffery · Bushnell, FLBuilt 1975 · S/N 15077600 N6235KCall One Inc · Clarinda, IABuilt 1975 · S/N 15077602 N6246KRussell Dustin D · Carthage, TXS/N 15077606 N6250KOlson Terry L · Rapid City, SDS/N 15077608 N6253KShiffer Lyle J · Waterford, MIBuilt 1975 · S/N 15077610 N6260KTrausch Alfred F · Huntsville, ALBuilt 1975 · S/N 15077614 N6263KMakeever Robert L Trustee · Bucyrus, OHBuilt 1975 · S/N 15077616 N6266KAero Maintenance Inc · Vancouver, WABuilt 1975 · S/N 15077617 N6282KLowder Harold E · Fresno, CAFirst renewal noticeBuilt 1975 · S/N 15077624 N6287KWilliams Jimmy Z · Sherman, TXBuilt 1975 · S/N 15077625 N6288KCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1975 · S/N 15077626

Back to Cessna 150M