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.

N35447Clark Dana Gibbs Trustee · Arlington, TXS/N 6352N35448Moreau Raymond L · Slidell, LABuilt 1941 · S/N 6353N3544PClark John W · New Philadelphia, OHBuilt 1955 · S/N 22-3300N35452Shannon Todd J · Mitchell, SDBuilt 1941 · S/N 6357N35457Mckeen Charles D · Howard Lake, MNBuilt 1941 · S/N 6362N35458Eyries LLC · Mankato, MNBuilt 1941 · S/N 6363N3545ARp Sky Ranch LLC · Lewes, DEBuilt 1953 · S/N 22-1819N35462Depaso Sean R · Pray, MTBuilt 1941 · S/N 6366N3546ZPerkins Todd M · Lake Alfred, FLBuilt 1960 · S/N 22-7455N35484Augustin David J · Murfreesboro, TNS/N 6388N3548PHalley Dan R · Avery, TXBuilt 1955 · S/N 22-3304N35494Larrivee Jules P · Kent, WABuilt 1941 · S/N 6397N35499Turner David · Frenchtown, NJBuilt 1941 · S/N 6404N354GFN354gf LLC · Daytona Beach, FLS/N 5-654N3550MJopson Charles M · Etna, CABuilt 1947 · S/N 12-2395N3550PYates Darren L · Collinsville, OKBuilt 1955 · S/N 22-3306N3550ZMcmillian Dean R · Wasilla, AKBuilt 1960 · S/N 22-7461N35511Hammond William R · Hustonville, KYBuilt 1941 · S/N 6421N3551ZAlpine Cable & Construction Inc · Grand Junction, COBuilt 1960 · S/N 22-7462N35529Registration Pending · Trinity, NCRegistration pendingBuilt 1941 · S/N 6434N3552ZMccartney David J · Lake Stevens, WABuilt 1960 · S/N 22-7463N3554ZJacobi Gregory A · Alex, OKBuilt 1960 · S/N 22-7465N3555MCade Chris · Canton, TXS/N 12-2403N3556MHubbert Robert · Azle, TXS/N 12-2501N3556PPlanes & Things Inc · Collinsville, OKBuilt 1955 · S/N 22-3312N35570Balunek Konrad K · Avon, OHS/N 6476N3557AWalter Jerry Douglas II · Palm Beach Gardens, FLS/N 22-1831N3557MMacniven Donald B · Colorado Springs, COS/N 12-2500N35589Bracale Glenn S · Anchorage, AKFirst renewal noticeS/N 5-693N3558AKra Investments LLC · Eastport, IDBuilt 1953 · S/N 22-1832N3558MHale Mitchell D · Chugiak, AKFirst renewal noticeS/N 12-2404N3558PConly Vernon J · Lehigh Acres, FLBuilt 1955 · S/N 22-3314N35595Airspace Aerial Media LLC · Saint Louis, MOBuilt 1941 · S/N 5-691N35598Lauterbach Paul D · Big Spring, TXS/N 4-1391N3559ZLapp Matthew J · Bonners Ferry, IDBuilt 1960 · S/N 22-7472N355JPBryant Bruce B · Raymond, KSBuilt 1955 · S/N 22-3311N35601Stinnett Spencer P · Athens, ALS/N 5-694N35604Welch Troy O · Graford, TXS/N 5697N35607Woodham Jesse C III · Thomasville, GAS/N 5-700N3560ACoffee Barry L · Auke Bay, AKBuilt 1953 · S/N 22-1834N3560PRichardson Billy J · Friendswood, TXBuilt 1955 · S/N 22-3316N3560ZBolding Ronald B · Aguila, AZBuilt 1960 · S/N 22-7474N35610Cox John E · Tucson, AZBuilt 1941 · S/N 5-704N35613Letourmeau Jaffe B · Olympia, WABuilt 1941 · S/N 5-706N35620Baker Ryan · Memphis, TNBuilt 1941 · S/N 5-714N35622Bailey Carlton D Jr · Huntington, WVBuilt 1941 · S/N 5-715N35624Watson Joshua J · Wilton, CAS/N 5-717N3562AHedin Andrew D · Hutchinson, MNS/N 22-1836N3563AHa Donggi · Lawrenceville, GABuilt 1953 · S/N 22-1837N3563MInternational Air Services Inc Trustee · Carson City, NVS/N 12-2411
Back to AD 99-01-05 R1