Skip to content

Registered aircraft · 1,121

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 ('2072821', '2070107')
  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 ('2072821', '2070107')
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.

N4364QStotts Boys Aviation LLC · Corcoran, MNBuilt 1973 · S/N 18502239 N4407RRhyneer Loren S · Anchorage, AKBuilt 1976 · S/N 18502946 N4410TLavin Gregory S · Chugiak, AKBuilt 1982 · S/N 18504335 N44309Urstadt Chris M · Girdwood, AKBuilt 1978 · S/N 18503486 N4433RWtf Partnership · Anchorage, AKBuilt 1976 · S/N 18502953 N4443RCold Region Air LLC · Fairbanks, AKBuilt 1976 · S/N 18502957 N4448RBell F Robert · Anchorage, AKBuilt 1976 · S/N 18502960 N4471RMurray Carol A · Hilo, HIBuilt 1976 · S/N 18502964 N4477RDyer George C · Victor, MTBuilt 1976 · S/N 18502967 N4483RRuf Timothy · Anchorage, AKBuilt 1976 · S/N 18502969 N4492Triego Inc · Dumas, TXBuilt 1976 · S/N 18502971 N44TUOglesby John B · Graford, TXBuilt 1978 · S/N 18503616 N4504NHayton James B · Sedro Woolley, WAS/N 18502550 N4506CIliamna Copper River Fly Fishing Lodge LLC · Livingston, MTBuilt 1974 · S/N 18502576 N4594ELingo Joshua B · Lake Village, ARBuilt 1979 · S/N 18503805 N45DSDcd Agriculture LLC · Franktown, COS/N 18503111 N4611EFife Jeffrey Ryan · Seminole, FLS/N 18503813 N4638EMorelock Colleen P Trustee · Beavercreek, OHS/N 18503822 N4640EState Of Utah · Salt Lake City, UTBuilt 1979 · S/N 18503824 N4644CMassmanf Darrel F · Ogdensburg, WIBuilt 1974 · S/N 18502585 N4646CWilliam Michael Moody · Anchorage, AKBuilt 1975 · S/N 18502586 N4649EStanberry Carl W · Anchorage, AKS/N 18503830 N4661CZiesmer Richard A · University Place, WABuilt 1974 · S/N 18502589 N4663CKnox William D · Denver, COBuilt 1974 · S/N 18502590 N4675CLane Robert W · Palmer, AKBuilt 1974 · S/N 18502592 N4688CAeropod Inc · Aurora, COBuilt 1976 · S/N 18502877 N4689CAeropod Inc · Aurora, COBuilt 1974 · S/N 18502596 N4690CGreen Aviation Inc · Manchester, MEBuilt 1974 · S/N 18502597 N4691EJoy Solutions LLC · Wilmington, DES/N 18503842 N4698C98 Charlie LLC · Anchorage, AKBuilt 1974 · S/N 18502598 N4704ABrown Helicopter Inc · Pensacola, FLBuilt 1974 · S/N 18502426 N4711EOregon Seaplanes LLC · Canby, ORBuilt 1979 · S/N 18503845 N4724QDehart T James Trustee · Kalama, WABuilt 1978 · S/N 18503550 N4730EState Of Alaska · Kodiak, AKBuilt 1979 · S/N 18503848 N4737FJelm Gordon E · Aguila, AZBuilt 1978 · S/N 18503552 N4742EHangen Mark C · Flagstaff, AZS/N 18503853 N4752QBrown Timothy L · Liberty Lake, WABuilt 1978 · S/N 18503553 N4756EAero Missions Inc · Sylacauga, ALBuilt 1979 · S/N 18503862 N4757EHoogendorn Homer E · Wasilla, AKS/N 18503863 N4759ERatcliff Stephen B · Anchorage, AKBuilt 1979 · S/N 18503865 N4762EFly185 LLC · Estes Park, COBuilt 1979 · S/N 18503868 N4764BPratt Sean · Hampton, NHBuilt 1977 · S/N 18503371 N4766EWillard Raymond C · Wasilla, AKBuilt 1979 · S/N 18503872 N4786QMcgregor Daniel A · Denali Park, AKBuilt 1978 · S/N 18503556 N47TLObendorf Phillip G · Parma, IDBuilt 1976 · S/N 18503185 N4800QVan Bortel Inc · Victor, NYBuilt 1978 · S/N 18503562 N4810Cox John C · Justiceburg, TXBuilt 1980 · S/N 18504111 N4814ESchwartz Andrew T · Bethesda, MDS/N 18503879 N4820EHogan Mark C · Sisters, ORBuilt 1979 · S/N 18503880 N4825EParis Enterprises LLC · Atlanta, GABuilt 1979 · S/N 18503883

Back to Cessna A185F