Skip to content

Registered aircraft · 26,231

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:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') 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:94-05-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
  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:94-05-05-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
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.

N33526Hockett Patricia A Trustee · Granbury, TXBuilt 1944 · S/N 2360A N33551Ottem David L · Othello, WABuilt 1945 · S/N 13989 N3356VCavu Pilot LLC · Powell, TNBuilt 1974 · S/N 15076471 N3357ABeachum Norman L · Foristell, MOBuilt 1953 · S/N 18-3004 N3357JHagghult Christer · Bonney Lake, WABuilt 1967 · S/N 15066057 N33585Cranor Clayton L · North Pole, AKBuilt 1945 · S/N 14062 N3358JBlue Chip Enterprises Inc · Clayton, NCBuilt 1967 · S/N 15066058 N3359JGaler Charles J · Irvington, ALBuilt 1967 · S/N 15066059 N3359VArcher Lee R · Redondo Beach, CABuilt 1974 · S/N 15076473 N335CCT Minus 9 LLC · Three Lakes, WIBuilt 2008 · S/N CC11-00079 N335JBComer Nathan A · Statesville, NCBuilt 2007 · S/N AL-1088 N335JCAlexander Melodie A · Lees Summit, MOBuilt 1956 · S/N 28785 N3360JStewart Roger · Lenexa, KSBuilt 1967 · S/N 15066060 N33614Dart Greg · Mayville, NYBuilt 1999 · S/N 1 N3362HMcavay Thomas Jacob · Sophia, NCS/N 3987 N3362JLivingston Rod W · Tuttle, NDBuilt 1967 · S/N 15066062 N3363HBailey Riley W Jr · Ada, OKS/N 3988 N3364JSlawski Michael E · Tucson, AZBuilt 1967 · S/N 15066064 N3364KShadick Roger R · Eagle River, WIBuilt 1946 · S/N 1357 N3365Harvey Donald W · Concord, NCS/N 24 N3366KWilson Stephen A · Granbury, TXBuilt 1946 · S/N 1359 N3368KFink Jeffrey C K · Austin, TXBuilt 1946 · S/N 1361 N336DDNewman Christopher J · Lorena, TXBuilt 1960 · S/N 47254 N336RSAirspeed Marketing LLC · Phoenix, AZS/N 17252228 N3370KMinor James F · Lake Dallas, TXBuilt 1946 · S/N 1363 N3370VHolladay Aviation LLC · Jacksonville, FLBuilt 1974 · S/N 15076477 N33717Beck Gary E · Richlands, NCBuilt 1941 · S/N C13021 N3372HPapich William · Boston, NYBuilt 1946 · S/N 3997 N3372VSimmons Robert J · Rising Fawn, GABuilt 1974 · S/N 15076478 N3373BManley Steven T · Dallas, TXBuilt 1965 · S/N 17253577 N3375ZHall James E III · Lumber Bridge, NCBuilt 1960 · S/N 18-7250 N3376VHill Craig · Memphis, TNBuilt 1974 · S/N 15076481 N3377JGriffith Scott · Hewitt, TXBuilt 1967 · S/N 15066077 N3377VGardner Terrence L · Pittsboro, NCS/N 15076482 N3378HTopken Erick W · Greeley, COBuilt 1946 · S/N 4003 N3378KGarcia Michael J · La Verne, CABuilt 1946 · S/N 1371 N337CLWoelk Egbert · North Andover, MABuilt 1998 · S/N C0037 N337ECrosswhite Dan F · Axtell, TXBuilt 1946 · S/N 1303 N337ESDucote David A · Jeanerette, LABuilt 2023 · S/N KA20342475 N337RMErfle Gordon A · Rapelje, MTS/N 5-338 N337XCHoover Rodney A · Wasilla, AKBuilt 1966 · S/N 15062891 N3380JEsparza Edel · Chula Vista, CABuilt 1967 · S/N 15066080 N3383HMessina David A · Currituck, NCBuilt 1946 · S/N 4008 N3384VNewby Aviation LLC · Pingree Grove, ILS/N 15076484 N3385JGonzales Mark S · Dothan, ALS/N 15066085 N3385KSalmonsen James A · Oswego, NYBuilt 1946 · S/N 1378 N3386VFrg III Inc DBA · Lincoln Park, NJBuilt 1974 · S/N 15076486 N3387JMy Piper Pacer LLC · Everett, WAS/N 15066087 N3388KMartens John J · Sierra Madre, CABuilt 1946 · S/N 1381 N3388NMeggers Darin R · Baker, MTBuilt 1946 · S/N 22589

Back to AD 94-05-05 R1