Skip to content

Registered aircraft · 1,300

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 ('2072306', '2072307')
  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 ('2072306', '2072307')
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.

N243BDBennett Reed J · Reno, NVBuilt 1956 · S/N 20591 N2443DWeber Blake N · Sisters, ORBuilt 1952 · S/N 20595 N2444DBennett James E · Fredericksburg, TXBuilt 1952 · S/N 20596 N2446DGreen Griffin LLC · Powell, OHS/N 20598 N2448DDrake Dwayne D · Fairbanks, AKS/N 20600 N2449DEdwards Samuel W · Shady Shores, TXBuilt 1952 · S/N 20601 N2455DBurton Douglas M · Chehalis, WABuilt 1952 · S/N 20599 N2457DSpindler Michael A · Fairbanks, AKBuilt 1952 · S/N 20609 N2458DKasica Stanley J · New Britain, CTBuilt 1952 · S/N 20610 N2459DShaw Brian W · Bemidji, MNS/N 20611 N2467DKaras Alyssa · Henderson, NVBuilt 1952 · S/N 20619 N2469DPierce Jerri L · Ozona, TXBuilt 1952 · S/N 20621 N2474DDavidson Chad E · Roxton, TXBuilt 1952 · S/N 20626 N2475DGresley Ross A · Catawba, NCS/N 20627 N2480DBush Joseph · Coalinga, CABuilt 1952 · S/N 20632 N2481DMandiola Alexander S · Key Biscayne, FLBuilt 1952 · S/N 20633 N2482DRiegel Frederick E · Houston, OHBuilt 1952 · S/N 20634 N2483DBrogden Aviation LLC · Olathe, KSBuilt 1952 · S/N 20635 N2485DDraggin Tail Pilots LLC · Prospect, PABuilt 1952 · S/N 20637 N2487DBlue Four Aviation LLC · North Pole, AKBuilt 1952 · S/N 20639 N2488DStokes David R · Sleepy Hollow, ILBuilt 1952 · S/N 20640 N2489DClark Joseph F III · New Smyrna Beach, FLBuilt 1952 · S/N 20641 N2494DPristo Paul J · Scottsdale, AZBuilt 1948 · S/N 20646 N2500C2500 Charlie LLC · Wilmington, DEBuilt 1953 · S/N 26144 N2501CLloyd Peter M · Walnut Creek, CAFirst renewal noticeBuilt 1953 · S/N 26145 N2504CHain Walter J · Mchenry, ILBuilt 1954 · S/N 26148 N2507CLagrone Dawnelle E · Longview, TXBuilt 1954 · S/N 26151 N250KBodrero Roger Jay · Outlook, WABuilt 1952 · S/N 20659 N2513DPetite Randall L · Lake Tapps, WABuilt 1952 · S/N 20665 N2514CPayne Jonathan R · Montgomery, ALBuilt 1954 · S/N 26158 N2514DWeindel Victoria E · Anchorage, AKBuilt 1952 · S/N 20666 N2515CCorbett Derek B · Durham, NCBuilt 1953 · S/N 26159 N2515DCooper Gerald W · Kennewick, WABuilt 1952 · S/N 20667 N2518DKimball Arthur C · Long Beach, CABuilt 1952 · S/N 20670 N2521CJago River Holdings LLC · Fairbanks, AKBuilt 1954 · S/N 26165 N2523CMchenry Thomas Michael Jr · Indialantic, FLBuilt 1954 · S/N 26167 N2523DThomsen Richard · Ladera Ranch, CABuilt 1952 · S/N 20675 N2524DSutton Aircraft Salvage LLC · Palmer, AKBuilt 1952 · S/N 20676 N2525CWeishaar Pilot · Odessa, WABuilt 1954 · S/N 26169 N2525DStephan Andrew Ryan · Eagle River, AKBuilt 1952 · S/N 20677 N2526DThomas Joel Matthew · Bethel, AKBuilt 1956 · S/N 20678 N2527CDuffy Lawrence R Jr · Vinemont, ALBuilt 1954 · S/N 26171 N2527DSidders Michael E · Big Lake, AKS/N 20679 N2531DAnderson Eric J · Great Falls, MTBuilt 1952 · S/N 20683 N2533CParker Michael T Trustee · Denton, TXBuilt 1954 · S/N 26177 N2533DAircraft Leasing LLC · Princeton, MNBuilt 1952 · S/N 20685 N2535CHulme Timothy L · Wickenburg, AZBuilt 1954 · S/N 26179 N2536CLibbey Eric · Santa Ynez, CABuilt 1954 · S/N 26180 N2536DWilliams Rod D · Steamboat Springs, COFirst renewal noticeBuilt 1952 · S/N 20688 N2537CNealon Robert M · Southbury, CTBuilt 1954 · S/N 26181

Back to Cessna 170B