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.

N8168CSmith Cameron R · Billings, MTFirst renewal noticeBuilt 1954 · S/N 18-3624N816JPKnox James P · Park Rapids, MNBuilt 1961 · S/N 18-7602N816WRDonovan Mark J DBA · Moultonborough, NHBuilt 1982 · S/N 18-8309017N8170CGibbens Brett S · Mc Grath, AKBuilt 1954 · S/N 18-3626N8171CPeed Aviation Inc · Casa Grande, AZBuilt 1954 · S/N 18-3627N8171DLueking Clyde F · Holdrege, NEBuilt 1957 · S/N 18-6100N8172CDrath Mark O · Reedsville, WIBuilt 1954 · S/N 18-3628N8173DAaa Flying Service Inc · Wellington, TXBuilt 1957 · S/N 18-6097N8174DKerzen Properties LLC · Fayetteville, ARBuilt 1957 · S/N 18-6101N8175DZweifel Douglas L · Anchorage, AKS/N 18-6102N8176CShaffer Glenn · Vinemont, ALBuilt 1954 · S/N 18-3632N8176DGulf Heavy LLC · Gulf Shores, ALBuilt 1957 · S/N 18-6104N8177DBackcountry Flying Experience Inc · Kalispell, MTBuilt 1957 · S/N 18-6105N817AAnderson Jennifer M · Biggs, CAS/N 22-121N8180CSnoopy Air LLC · Kalispell, MTBuilt 1954 · S/N 18-3637N8181DMuleshoe Ranch Inc · Belle Fourche, SDBuilt 1957 · S/N 18-6116N8183CHendrie Derek · Venus, FLBuilt 1954 · S/N 18-3642N8183DReabe Robert E · Waupun, WIBuilt 1957 · S/N 18-6118N8186CKelliher Tia Marie · Eagle River, AKBuilt 1954 · S/N 18-3645N8186KBlack Hills Soaring Club Inc · Rapid City, SDBuilt 1960 · S/N 25163N8187DSchmidt Darrell · Kimberly, IDBuilt 1957 · S/N 18-6122N8188CSlayden Steven M · Rhome, TXBuilt 1954 · S/N 18-3647N8189DWeese Chas K · Quinlan, TXBuilt 1957 · S/N 18-6124N818MAWelstad Blaine L · Newburg, NDS/N 18-6121N818RButler John · Hazelhurst, WIBuilt 1994 · S/N 1809084N818TAFoothill Aviation LLC · Iliamna, AKS/N 18-8818N818VMReitz Brian C · Tehachapi, CABuilt 1955 · S/N 22-3357N818WCCrawford Beau W · Willow, AKBuilt 1977 · S/N 18-7709111N819Huseby Kelly E · Hulett, WYBuilt 1974 · S/N 18-7409139N8190CBent James L Jr DBA · Palatine Bridge, NYS/N 22-2295N8190DMagnuson Lucile · Mc Grath, AKBuilt 1957 · S/N 18-6126N8191CLee Gerald R · Glennallen, AKBuilt 1953 · S/N 20-1106N8191DSwede Aviation LLC · Tucson, AZS/N 18-6127N8192CD&K Aviation Inc · Milford, IABuilt 1954 · S/N 18-4108N8192DGlasheen Sean T · Bethel, AKBuilt 1957 · S/N 18-6130N8194CWilliams Mark S · Lisbon, OHBuilt 1954 · S/N 22-2299N8194DPalin Todd M · Wasilla, AKBuilt 1958 · S/N 18-6132N8195AMundorf John P · Mullen, NEBuilt 1976 · S/N 187609013N8195DGray Richard B · Manley Hot Springs, AKBuilt 1957 · S/N 18-6133N8196CStrout Carl D · Centerburg, OHBuilt 1954 · S/N 22-2301N8196DWells Kris G · Barron, WIS/N 18-6134N8198CLee Jesse D · Pierre, SDBuilt 1954 · S/N 22-2303N8199CKiokun Edward I · Mekoryuk, AKBuilt 1954 · S/N 22-2304N819JBChance Billy M · Normangee, TXS/N 22-6693N81ARTredway Robert J · Prescott, AZBuilt 1954 · S/N 22-2364N81LSPedulla Rich · Wyalusing, PAS/N 22-6770N81PCNimbus Aviation LLC · Ponte Vedra Beach, FLBuilt 1957 · S/N 18 6013N81ZWWiens Zachary S · Portland, ORBuilt 1947 · S/N 12-3085N82006Marquiss Gary C · Gillette, WYBuilt 1978 · S/N 18-7809125N82016Armstrong John Russell Jr Trustee · Commerce, TXBuilt 1979 · S/N 18-7909052
Back to AD 99-01-05 R1