OpenAirDocs.org
AD 2005-08-06

Registered aircraft · 37

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

N101CXMoses Charles A III · West Friendship, MDBuilt 1983 · S/N 101 089N101LVRosenthal Bruce D · Wickenburg, AZS/N 10100264N116DMArea Code Adventures LLC · Virginia Beach, VAS/N 101A0343N130CASmith Douglas J · Waltham, MABuilt 1985 · S/N 101 A 0204N1691Wampler William R · Albuquerque, NMBuilt 1984 · S/N 101AP128N170PMLawrence Vincent J · Littleton, COBuilt 1983 · S/N 101A0098N186SSWarren Mark P · Memphis, TNBuilt 1987 · S/N 101-004N38KGDebacker Frank A · Highlands Ranch, COBuilt 1984 · S/N 101A0129N3TEShatto Michael L Jr · Klamath Falls, ORS/N 101A0198N55KGAustria Alfred N · San Jose, CAS/N 101A0200N56DTBraner Alan R · Punta Gorda, FLS/N 101A0201N57RHWood David A · San Diego, CAS/N 101A0218N58KGMcguire James Jared · Athens, PAS/N 101A0203N599JHMirzayan Varoojan Y · Fresno, CAS/N 101 084N626CAMellor Dennis L · Sacramento, CAS/N 101-087N628CAMocho Mark S · Moriarty, NMBuilt 1984 · S/N 101A0154N629CAHayes Steven R · Frankfort, KYBuilt 1983 · S/N 101A0088N633CAPrice Brian H · Westminster, COS/N 101 083N634CACowan Rena E · Pleasant Hill, ORS/N 101A0118N635CAWaldo Charles N · West Ossipee, NHS/N 101A0119N636CAMurray James E · Naperville, ILBuilt 1984 · S/N 101A0120N637CATsidjs LLC · Lehighton, PAS/N 101A0121N638CARamus Sebastien A · Olathe, KSS/N 101A0122N639CABarton Ronald · Camp Verde, AZS/N 101A0124N640CAPearson Marilyn G · West Hartford, CTS/N 101AP186N643CAFadden Michael D · Margate City, NJS/N 101A0188N644CALeonard Steven E · Wichita, KSS/N 101 090N645CAZanon John T · Uhrichsville, OHBuilt 1984 · S/N 101A0156N70FPFinger Lakes Soaring Club Inc · Dansville, NYBuilt 1985 · S/N 101A0202N723PJBerry Wallace · Lafayette, ALS/N 101A0199N90KGRobards C David · Sparks, NVBuilt 1983 · S/N 101A0099N92KGPumphrey Robert L · Greensburg, INBuilt 1983 · S/N 101A097N945CSGilbreath Michael L · Rochester, WAS/N 101 003N94KGSchibler Gregory W · Encinitas, CABuilt 1983 · S/N 101AP094N95KGBilyeu Jeffrey E · Reno, NVBuilt 1983 · S/N 101A0095N99KGXander Brian K · Grafton, VTS/N 101A0225N99WVBendorf Craig V · Woodbridge, VABuilt 1984 · S/N 101A0126
Back to AD 2005-08-06