Skip to content

Registered aircraft · 170

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

N4537KGirard Guillaume · Blaine, MNBuilt 1948 · S/N NAV-4-1537 N4545KEdwards Laurence Trustee · Crystal Lake, ILS/N NAV-4-1545 N4549KFitchen Christopher H · Poplar Grove, ILBuilt 1948 · S/N NAV-4-1549 N4552KDomalski Frank · Sylvania, OHBuilt 1948 · S/N NAV-4-1552 N4557KVoeckel Kirk · Tarentum, PAS/N NAV-4-1557 N4558KRankin Gary L · Vancouver, WABuilt 1948 · S/N NAV-4-1558 N4559KUSA Aircraft Leasing LLC · Hayden, IDS/N NAV-4-1559 N4567KHopgood Mark R · Park City, UTS/N NAV-4-1567 N4574KSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1948 · S/N NAV-4-1574 N4579KVallee Jean-Francois R · Everson, WABuilt 1948 · S/N NAV-4-1579 N4581KBas Part Sales LLC · Greeley, COBuilt 1948 · S/N NAV-4-1581 N4583KBailey David J · Festus, MOBuilt 1948 · S/N NAV-4-1583 N4584KJones Daniel P · Sacramento, CABuilt 1948 · S/N NAV-4-1584 N4597KRegistered aircraftBuilt 1948 · S/N NAV-4-1597 N4599KKrug George R III · Keller, TXS/N NAV-4-1599 N4606KJamieson David A · Madison, VAS/N NAV-4-1606 N4616KBrown Ronald D · Auburn, WABuilt 1948 · S/N NAV-4-1616 N4623KDeibel Trisha N · Minerva, OHS/N NAV-4-1623 N4625KMerchant David E · Huntsville, ALBuilt 1948 · S/N NAV-4-1625 N46380Knoll Thomas R · Ham Lake, MNS/N NAV41152 N46CWFeirman Daniel A · Pace, FLS/N NAV-4-2341B N4791KHanselman Ronald L Jr · Cresson, TXBuilt 1949 · S/N NAV-4-1791 N4795KGrantham George F · Bush, LABuilt 1949 · S/N NAV-4-1795 N4799KSalgado Bahena Perfecto · Vancouver, WABuilt 1949 · S/N NAV-4-1799 N4807KWright Keith A · Waxahachie, TXS/N NAV-4-1807 N4813KNewbury Terry A · Florence, ALBuilt 1949 · S/N NAV-4-1813 N4821KRegistered aircraftBuilt 1949 · S/N NAV-4-1821 N4825KAcme Aero LLC · Lewes, DES/N NAV-4-1825 N4833KNoll Roddy B · Apison, TNBuilt 1949 · S/N NAV-4-1833 N4847KRocha Julio Cesar · Redding, CAS/N NAV-4-1847 N4851KFulk Richard D · Keller, TXBuilt 1949 · S/N NAV-4-1851 N4853KBeaver Bradford P · Miami, FLBuilt 1949 · S/N NAV-4-1853 N4858KYarbrough Lloyd Houston · Harlingen, TXBuilt 1949 · S/N NAV-4-1858 N4862KSuggs Clyde C · Snow Hill, NCBuilt 1949 · S/N NAV-4-1862 N4866KNavion Aviation LLC · Littleton, COS/N NAV-4-1866 N4868KHeath David C · Winona, MSBuilt 1949 · S/N NAV-4-1868 N4869KTucker Robert B · Melba, IDBuilt 1949 · S/N NAV-4-1869 N4879KNorthwest Navion Inc · Arlington, WABuilt 1949 · S/N NAV-4-1879 N4888KHawthorne Chad A · Post Falls, IDBuilt 1949 · S/N NAV-4-1888 N4890KYoung Bobby R · Burnsville, NCBuilt 1949 · S/N NAV-4-1890 N4923KKlark Holdings Corp · Bellefontaine, OHBuilt 1949 · S/N NAV-4-1923 N4932KDavis Charles H Jr · Manchester, MIBuilt 1949 · S/N NAV-4-1932 N4956KSilver Wings Trading LLC · Leander, TXBuilt 1949 · S/N NAV-4-1956 N4969KMills William R · Louisville, KYBuilt 1949 · S/N NAV-4-1969 N4977KKbld LLC · Buchanan, MIS/N NAV-4-1977 N5109KFoster Adam J · Houston, TXBuilt 1950 · S/N NAV-4-2009 N5184KGilbert David G · Chewelah, WABuilt 1950 · S/N NAV-4-2084 N51TAHill Charles T Jr · Huntsville, ALBuilt 1947 · S/N NAV-4-725 N5356KAmped Aviation LLC · Philipsburg, MTS/N NAV-4-2256B N721CMManint James E · Monticello, ILBuilt 1946 · S/N NAV-4-74

Back to Ryan NAVION