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.

N1820ACaley Robert M · Green, KSBuilt 1952 · S/N 18-1671N1823PGranger Joshua M · Rosebud, MTS/N 22-2603N1827PMechel Emil C · Toledo, OHBuilt 1955 · S/N 22-2607N1829AMcelligott Joseph P · Ione, ORBuilt 1952 · S/N 18-1679N1829PBoll Ryan C · Sheboygan, WIBuilt 1955 · S/N 22-2609N1830AMurphy Joshua T · South Lyon, MIBuilt 1952 · S/N 20-873N1830PRegistered aircraftS/N 222610N1831PFay Bernard E · Eagle, AKBuilt 1955 · S/N 22-2611N18338Carpenter Jeff D · Fairbanks, AKBuilt 1965 · S/N 18-8285N1833PJones Brian K · Scituate, MABuilt 1955 · S/N 22-2613N1834PHellyer James R · Darien Center, NYBuilt 1955 · S/N 22-2614N1835PVintage Restorers Ltd LLC · Windsor, COS/N 22-2686N1836ABhl Aviation LLC · Denver, COBuilt 1952 · S/N 20-875N1838AGray Shane Charles · Interlochen, MIBuilt 1952 · S/N 22-529N1838PLarsen Steve J · Colton, ORBuilt 1955 · S/N 22-2618N1841AJohnson Kevin L · Canyon, TXBuilt 1952 · S/N 18-1735N1843PAdams James · Quinlan, TXBuilt 1955 · S/N 22-2623N1846PGrumpy Aviation Ltd · Denver, COBuilt 1955 · S/N 22-2628N184WFSitkiewicz James P · Anchorage, AKBuilt 1959 · S/N 18-6961N184WLNastro Kristopher J · Fallon, NVBuilt 1968 · S/N 18-8721N1850AWells Kris G · Barron, WIBuilt 1952 · S/N 18-1684N1850PPeters Nicholas J · Eagle River, AKBuilt 1955 · S/N 18-4115N1852PBennack George H · Lyford, TXBuilt 1955 · S/N 18-4101N1853DBent James L Jr DBA · Palatine Bridge, NYS/N 18-53N1853PViersen Leonard J Trustee · Glennallen, AKBuilt 1955 · S/N 18-4117N1855AMoore Brandan D · Wasilla, AKBuilt 1952 · S/N 18-1681N1857PJanvrin Jerry M · Buffalo, SDBuilt 1955 · S/N 18-4124N1858ALow And Slow LLC · Bozeman, MTBuilt 1953 · S/N 18-1686N1861ABernstein Timothy D · Faith, SDS/N 18-1691N1869ATiberius Rex Aviation LLC · Carson City, NVBuilt 1952 · S/N 18-1697N1869WWolter Kenneth W · Wasilla, AKBuilt 1969 · S/N 18-8835N186TKing George W · Strykersville, NYBuilt 1953 · S/N 18-2300N1871ASkywagon Aero LLC · Wilmington, DES/N 18-1703N1876AKalarney Kerry T · Olathe, COBuilt 1952 · S/N 18-1712N1878ANapa Taildraggers Inc · Napa, CAS/N 18-1713N1878PLutter Jim L · Gann Valley, SDS/N 18-4157N1879ASale Reported · Eagle River, AKSale reported, pending cancellationS/N 18-1711N1879PWbs Coatings Inc · Grand Junction, COS/N 18-4158N1880PSt Jean Kurt Joseph · Homer, AKBuilt 1955 · S/N 18-4160N1882PAir Dakota Flite Inc · Hettinger, NDBuilt 1955 · S/N 18-4163N1883PDavis Tom C · Belle Fourche, SDBuilt 1955 · S/N 18-4164N1884PStoica Michael J Jr · East Liverpool, OHBuilt 1955 · S/N 18-4165N1886AGriffith Richard B · Sycamore, ILBuilt 1952 · S/N 18-1719N1886PAlligood Allen K · Wasilla, AKBuilt 1955 · S/N 18-4169N1887AErickson Paul F · Wasilla, AKS/N 18-1725N1888AAlaska Tailwheel LLC · Fairbanks, AKBuilt 1952 · S/N 18-1718N1889PVeatch William E · Hood River, ORBuilt 1955 · S/N 18-4175N1890AJohnson Air LLC · Anselmo, NEBuilt 1952 · S/N 18-1723N1890PParker Paul R · Summit Point, WVS/N 22-2632N1891AEntriken Birch N · Reno, NVFirst renewal noticeBuilt 1952 · S/N 18-1891
Back to AD 99-01-05 R1