Skip to content

Registered aircraft · 40,473

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
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.

N6183Golden Age Air Museum · Bethel, PABuilt 2012 · S/N GA6183 N61832Prop Wash Aero Inc · Senoia, GABuilt 1975 · S/N 17264828 N61834Offerman Leo · Emily, MNBuilt 1975 · S/N 17264829 N61835Epic Aviation Leasing LLC · Puyallup, WAS/N 17264830 N61837Park Richard J · Devol, OKBuilt 1975 · S/N 17264831 N61839Fixen Jimmie Trustee · Lynd, MNBuilt 1975 · S/N 17264833 N6183WMartin Neal O · Reno, NVS/N 28-20207 N6183XCanipe Kendall L · Shelby, NCBuilt 1981 · S/N M-2350 N61840Jimenez Cruz Juan C · Mayaguez, PRS/N 17264834 N61841Burggraf Sean Hj · Grand Rapids, MNS/N 17264835 N61842Skywalker Flight Schoool LLC · Adrian, MIBuilt 1975 · S/N 17264836 N6184JInverted Holdings LLC · Newnan, GABuilt 1976 · S/N 28-7615324 N61852Knight-Graham Michael L Trustee · Truckee, CABuilt 1975 · S/N 17264844 N61856Paraclete Sky Adventures LLC · Raeford, NCBuilt 1975 · S/N 17264847 N61859Jprg Aviation Inc · Orlando, FLBuilt 1975 · S/N 17264849 N6185DOmega 1 Corp · Middletown, DEBuilt 1957 · S/N 18-5474 N6185HSargent Patrick S · Bicknell, INBuilt 1977 · S/N 28-7890215 N6185JYankee Pilots Inc · Haverhill, MABuilt 1976 · S/N 28-7615325 N6185RSkywalker Ranch LLC · Dover, DEBuilt 1979 · S/N 172RG0108 N61866Wings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17264852 N61868Jamm Aircraft LLC · Sterling, OHBuilt 1975 · S/N 17264854 N6186JRegistration Pending · Sebastian, FLRegistration pendingBuilt 1976 · S/N 28-7615326 N6186WWerren Carroll E · Concord, NHFirst renewal noticeBuilt 1964 · S/N 28-20210 N61870Dfu LLC · Boise, IDBuilt 1975 · S/N 17264856 N61872Griffith William C III · Indianapolis, INBuilt 1975 · S/N 17264857 N61873Umo Seneca LLC · Raleigh, NCBuilt 1975 · S/N 17264858 N61875Knight Aviation I LLC · Prescott, AZBuilt 1975 · S/N 17264860 N61876Ferrara James L Jr · Wellington, NVBuilt 1975 · S/N 17264861 N61878Tate John M · Boonton, NJBuilt 1975 · S/N 17264863 N61879Lake Elmo Aero LLC · Lake Elmo, MNBuilt 1975 · S/N 17264864 N6187WAerospace Trust Management LLC Trustee · Wilmington, DES/N 28-20213 N61884Purfield Sara E · West Richland, WABuilt 1975 · S/N 17264866 N61889Registration Pending · Dallas, PARegistration pendingBuilt 1975 · S/N 17264870 N6188JRaveesh Cn · Gladstone, MIBuilt 1976 · S/N 28-7690367 N61890Stallion Leasing LLC · Louisville, KYBuilt 1975 · S/N 17264871 N61891Higgins Jerome N · Oak Harbor, WABuilt 1975 · S/N 17264872 N61892Loughridge Robert M III · Prattville, ALBuilt 1975 · S/N 17264873 N6189ZHall William B · Vincentown, NJBuilt 1960 · S/N 25-223 N618ARoberts Jeffrey M · Markleville, INBuilt 1975 · S/N AA5A-0006 N618BSBauer Thomas G · Sturgeon Bay, WIBuilt 2018 · S/N 7 N618DCrockett Brandon A · Hollis Center, MEBuilt 2003 · S/N 001 N618EMMoffitt Michael E · Kent, IABuilt 1971 · S/N 28-7205009 N618FLDexter Development LLC · Kingfield, MEBuilt 1971 · S/N 28-7125503 N618JMaldonado Jose Ivan · Hahira, GABuilt 1992 · S/N RV-4-1569 N618MNEack Kenneth B · White Rock, NMBuilt 1977 · S/N 172-69028 N618RJDr Ghods Dmd Inc · Las Vegas, NVBuilt 2003 · S/N 90082 N618TMTuskegee Airmen National Historical Museum · Detroit, MIBuilt 1979 · S/N 17273346 N61901Lalaguna Ricardo · Orlando, FLBuilt 1975 · S/N 17264880 N6190DTap Solutions Inc · San Diego, CABuilt 1979 · S/N 17272623 N6190RSundance Flying Club Inc · Palo Alto, CABuilt 1979 · S/N 172RG0110

Back to AD 80-04-03 R2