OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,639

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:99-01-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:99-01-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.

N9880HAbell Alan R · Elgin, ILBuilt 1943 · S/N 51434N9881PSale Reported · Spartanburg, SCSale reportedBuilt 1975 · S/N 25-7556210N9882DUsda Aphis Ws Atoc · Cedar City, UTBuilt 1959 · S/N 18-6904N9883DGalyean Terry L · Kenai, AKBuilt 1959 · S/N 18-7010N9883PMinden Soaring Club Inc · Minden, NVBuilt 1975 · S/N 25-7556211N9884DMartensen Marten · Anchorage, AKS/N 18-6905N9884PVandegriff Cody E · Eagle River, AKBuilt 1976 · S/N 18-7709007N98851Jacques Jerry Joseph · Iliamna, AKS/N 18-7188N9885DBarney Jeff S · Fairbanks, AKS/N 18-6907N9885PTriple Cub Aviation LLC · Greenbush, MIBuilt 1976 · S/N 18-7709008N98864Williams Francis B III · Meridian, GABuilt 1946 · S/N 19126N9887DRegistered aircraftBuilt 1959 · S/N 18-6911N9889DBorth Johnny D · Meade, KSBuilt 1959 · S/N 18-6914N98900Bruton Jerry C Trustee · Wasilla, AKS/N 12-246N98901Haley Lawrence E II · Naples, FLS/N 12-247N98906Ison Larry D · Anchorage, AKBuilt 1946 · S/N 12-251N98910Wikle Artic C · Wasilla, AKBuilt 1946 · S/N 12-255N98912Allen John B · Sutter Creek, CABuilt 1946 · S/N 12-258N98917Lee Mark D · Palmer, AKBuilt 1946 · S/N 12-268N98919Gehring Robert A · Rubicon, WIBuilt 1946 · S/N 12-270N98922Mitchell Mark J · Wrangell, AKFirst renewal noticeBuilt 1946 · S/N 12-275N98927Deleon Joseph M · Saint Petersburg, FLFirst renewal noticeBuilt 1946 · S/N 12-279N9892PArizona Soaring Inc · Maricopa, AZBuilt 1975 · S/N 25-7556215N98932Podeweltz Wayne Leo · Merrill, WIBuilt 1946 · S/N 12-285N98935Meketa George C · La Vernia, TXS/N 12-290N9893DGoicoechea Mitchell J · Elko, NVS/N 18-6919N98941Flaglor Thomas R · Mosheim, TNS/N 12-296N98944Phelps Douglas E · Salem, ORBuilt 1946 · S/N 12-299N98959Delaware Corp · Topping, VABuilt 1946 · S/N 12-313N98961Knox Norman B · Billings, MTBuilt 1946 · S/N 12-315N98962Woodward Lowell L · Alpine, TXBuilt 1946 · S/N 12-316N98965Cook Steven A · Vineland, NJBuilt 1946 · S/N 12-320N9896PLees Aerial Spraying Inc · Aberdeen, IDBuilt 1975 · S/N 25-7556219N98971Whitaker Eric Lee · Detroit, TXBuilt 1946 · S/N 12-327N98978Harmon Jon E · Turner, MTBuilt 1946 · S/N 12-335N98979Mc Bride Robert W Jr · Cedar Park, TXBuilt 1946 · S/N 12-336N9897DRobinson Scot K · Powderville, MTBuilt 1959 · S/N 18-6923N9897PMississippi State University Soaring Club Inc · Mississippi State, MSBuilt 1975 · S/N 25-7556220N98985Sanker Frank Trustee · Keller, TXBuilt 1946 · S/N 12-342N98992Mike Pikovsky Aviation LLC · Plymouth, MNBuilt 1946 · S/N 12-350N98994Lindeen Michael L · Anchorage, AKBuilt 1946 · S/N 12-352N98999Rodenhouse Robert H · Port Orange, FLBuilt 1946 · S/N 12-360N989AMcghan Corey A · Big Lake, AKS/N 12-2590N98AMRichter Rick D · Anchorage, AKS/N 18-03AMN98AWBrewer Duncan J · Kenai, AKS/N 12-2250N98EEMaples Jeffery · Wilmington, DEBuilt 1980 · S/N 18-8009014N98GKPantone Matthew J · Morgan, UTBuilt 1968 · S/N 18-5650N98PKSullivan David M · West Ossipee, NHBuilt 1964 · S/N 188157N98RKKeith Robert W · Austin, TXS/N 18-09024N98SATail Slide Aviation LLC · Wilmington, DEBuilt 1976 · S/N 18-7609088
Back to AD 99-01-05 R1