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.

N82017Russell Alex B Jr · Soldotna, AKBuilt 1978 · S/N 18-7809118N8201CSheard Scott R · Chugiak, AKS/N 22-2306N82022Hard Luck Aviation LLC · Tok, AKBuilt 1978 · S/N 18-7809113N8202CMoore Sharkie A · Houston, TXBuilt 1954 · S/N 22-2307N82035Troia Andrew · Homer, AKBuilt 1978 · S/N 18-7809115N82053Kleinknecht Richard C · Burtchville, MIBuilt 1977 · S/N 18-7709141N82057Morelli Michael L · Eagle River, AKBuilt 1978 · S/N 18-7809120N82058Hunt Brackston C · Elaine, ARS/N 18-7909051N8205CHasting Grant William · Covington, WAS/N 22-2310N82063Richards Brian W · Soldotna, AKBuilt 1978 · S/N 18-7809121N82064Wells Joseph E · Dorchester, SCBuilt 1978 · S/N 18-7809123N82065Yundt Joshua J · Wasilla, AKBuilt 1978 · S/N 18-7809124N82067Knutson Wayne R · Thompson, NDS/N 25-2792N8206CCalvert Charles W · Ranger, TXBuilt 1954 · S/N 22-2311N82071Vintage Aircraft LLC · Leesville, SCBuilt 1979 · S/N 18-7909054N82076Kustatan Leasing LLC · Nikiski, AKS/N 18-7909056N82084Dorion David R · Asotin, WABuilt 1979 · S/N 18-7909058N82096Mid Atlantic Soaring Assoc · Frederick, MDBuilt 1979 · S/N 18-7909053N820AEkroot Jordan M · Grand Marais, MNBuilt 1951 · S/N 22-123N82100Rawson Rodney L · Ellenton, FLS/N 18-7809127N82109Hurlburt Ward B · Dillingham, AKS/N 18-7809130N82116Bennett Lynn · Juneau, AKBuilt 1978 · S/N 18-7809131N8214CRegistered aircraftBuilt 1954 · S/N 18-3655N82155Maroney Thomas L · Wasilla, AKBuilt 1975 · S/N 18-7809135N82165Piper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 18-7809136N82166Minuteman Aviation Inc · Missoula, MTBuilt 1978 · S/N 18-7809137N82168Earth Center Adventures Inc · Haines, AKBuilt 1979 · S/N 18-7909061N82169Patterson Colin G · Ballston Spa, NYBuilt 1979 · S/N 18-7909063N8216CYoung Mikaela R · Fairbanks, AKS/N 18-4444N82172Wadekamper Leo V · Helena, MTBuilt 1979 · S/N 18-7909064N8218Kornegay Patrick C · San Benito, TXBuilt 1982 · S/N 18-8209005N82188Kubecka Daniel P · Edna, TXBuilt 1979 · S/N 18-7909068N82196Flying W Ranch Jv · Cooperstown, NDBuilt 1979 · S/N 18-7909070N821PCJones Clark L · Cave Creek, AZS/N 18-8031N82209Pearl Darwyn L · Bend, ORBuilt 1978 · S/N 18-7809153N82213Anderson Stephen A · Yuba City, CABuilt 1979 · S/N 18-8009031N82225Dow Clifford G II · Falmouth, MEBuilt 1979 · S/N 18-7909072N82236Ingle Nicholas A · Cora, WYBuilt 1979 · S/N 18-7909079N82253Dirt Strip Dirtbags LLC · Whitefish, MTS/N 18-7909082N82259Pedersen Eric D · Mccall, IDBuilt 1979 · S/N 18-7909084N8225CHastings Heidi R · Wasilla, AKBuilt 1954 · S/N 18-3668N82267Ellis Stanley W · Bakersfield, CAFirst renewal noticeS/N 18-7909086N8226CTyler Joseph Virgin · Wasilla, AKFirst renewal noticeBuilt 1954 · S/N 18-3669N82274Harris James M · Bemidji, MNBuilt 1979 · S/N 18-7909087N82285Horton Charles M · Wilkeson, WABuilt 1979 · S/N 18-7909089N82293Egolf Mark A · Nine Mile Falls, WABuilt 1979 · S/N 18-7909090N822REEaton Ray · Zeeland, MIBuilt 1964 · S/N 22-9802N82305Akima Logistics Services LLC · Usaf Academy, COBuilt 1976 · S/N 25-7656070N8231EArctic Backcountry Flying Service LLC · Kotzebue, AKBuilt 1957 · S/N 18-5590N82325Hutchison John · Wasilla, AKBuilt 1977 · S/N 18-7709143
Back to AD 99-01-05 R1