Skip to content

Registered aircraft · 40,472

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.

N13732Bay Lux Ventures LLC · Tampa, FLBuilt 1974 · S/N 17262978 N13733Kelleher James · Nevada City, CABuilt 1976 · S/N 17702462 N13734Red Bird Flyers LLC · Acton, MABuilt 1976 · S/N 17702463 N13737Crosswinds Flight Center Inc · Drums, PABuilt 1974 · S/N 17262983 N13739Maroldy Robert S · Gahanna, OHBuilt 1974 · S/N 17262985 N1373EEagle Aviation LLC · Spearfish, SDBuilt 1978 · S/N 17270975 N1373UWestberg Larry A · Milton, WIBuilt 1976 · S/N 17267044 N1373WGarces Manuel E · Jefferson, GABuilt 1963 · S/N 2654 N13740Gigax Steven G · Archbold, OHBuilt 1976 · S/N 17702465 N13741Rasmussen Tyler R · Independence, IAS/N 17262987 N13747Namund LLC · Roscommon, MIBuilt 1976 · S/N 17702466 N13748Ries Farms LLC · Hastings, MNS/N 17262989 N1374EKjeldgaard James K · Fremont, NEBuilt 1978 · S/N 17270976 N1374TLuckinbill LLC · Columbus, MTBuilt 1982 · S/N K-6 N1374USkydance Aviation LLC · Norfolk, VABuilt 1976 · S/N 17267045 N1374WWade Deborah D · Mineral Wells, TXBuilt 1963 · S/N 2655 N13751Stegmaier Ann C · Eagan, MNBuilt 1974 · S/N 17262992 N13752Coffman Aviation Inc · Jacksonville, FLBuilt 1974 · S/N 17262993 N13753Reeves Christopher A · Statesville, NCBuilt 1974 · S/N 17262994 N13754Durrum Frank D III · Mount Pleasant, TXBuilt 1974 · S/N 17262995 N13756Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 1976 · S/N 17702468 N13757Nelson Robert Brett · Point Roberts, WABuilt 1976 · S/N 17702469 N1375CConn James Michael · Alexandria, MNBuilt 1977 · S/N 17702715 N1375HGdisis Ernie W · Racine, WIBuilt 1987 · S/N 260 N1375WAndrews Kevin M · Hermitage, TNBuilt 1963 · S/N 2656 N1376RParker Brian L · Columbus, GABuilt 1975 · S/N AA5-0776 N1376TSteflik Timothy · New Smyrna Beach, FLBuilt 1972 · S/N 28-7225486 N1376WMarling Russell Cole · Highlands, NCS/N 2657 N13770Countryside Academy · Benton Harbor, MIBuilt 1974 · S/N 17263001 N13778Weitekamp Shawn Paul · Roanoke Rapids, NCBuilt 1974 · S/N 17263003 N1377EFly Barely LLC · Manitowoc, WIBuilt 1978 · S/N 17270978 N1377MBuiqui Aerospace Corp · Kissimmee, FLBuilt 1972 · S/N 17260577 N1377RHendrix David S · Benbrook, TXBuilt 1975 · S/N AA5-0777 N1377TTheroux Theodore N · Rice Lake, WIBuilt 1972 · S/N 28-7225487 N1377UWifa (Washington International Flight Academy) LLC · Wilmington, DEBuilt 1976 · S/N 17267048 N13786Diapaola Anthony Sr · New Eagle, PABuilt 1974 · S/N 17263004 N1378MCavok LLC · La Vergne, TNBuilt 1972 · S/N 17260578 N13796Positive Attitude Ia LLC · Gaithersburg, MDBuilt 1974 · S/N 17263006 N1379BWiebe James R · Valley Center, KSBuilt 1982 · S/N 71 N1379TGordon William E · Summit, NJBuilt 1972 · S/N 28-7205290 N1379UHigh Flight Academy LLC · Allison Park, PABuilt 1976 · S/N 17267050 N137ALLegends Air Center LLC · Bentonville, ARBuilt 1976 · S/N 17268125 N137ASFlight Leasing Corp · Wilmington, DES/N ME-72 N137ATChamerlik William S · Spencer, TNBuilt 1977 · S/N 28-7816087 N137BCJrnd Corp · Lewes, DEBuilt 2003 · S/N 2843584 N137ERTn Tfc LLC · Nashville, TNBuilt 1993 · S/N 1527 N137FRMoores Aerospace Solutions LLC · Statesboro, GAS/N 17276630 N137FST Aviation Services Inc · Canovanas, PRBuilt 1975 · S/N 17266030 N137KStone Fish Aviation LLC · Fernandina Beach, FLBuilt 2000 · S/N 137 N137LCNine Kilo LLC · Sterling, VABuilt 2005 · S/N 90334

Back to AD 80-04-03 R2