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.

N38048Thiel Roger N · Washington, DCBuilt 1941 · S/N 5-854N3804PMadsen Theodore W · Gillette, WYBuilt 1955 · S/N 22-3493N3804ZCulbertson William Theodore · Helena, MTBuilt 1960 · S/N 18-7537N38055Stewart Emerson C · Waynesville, OHBuilt 1941 · S/N 5-870N3805PSpinner Family Lp · White City, ORBuilt 1955 · S/N 22-3494N3806MAbbott Cedric M · Buckfield, MEBuilt 1947 · S/N 12-2563N3806ZNamtvedt Erik · Wasilla, AKS/N 18-7539N38070Aas LLC · Ovid, MIBuilt 1941 · S/N 5-857N38079Wingnut Inc · Wilmington, DEBuilt 1941 · S/N 6775N3807MRenner Robert C · Erie, PABuilt 1947 · S/N 12-2729N3807PLuebber Jan D · Malaga, WAS/N 22-3496N38080Jenkins Michael D · Rigby, IDBuilt 1941 · S/N 4-1538N3808ASturges George S Jr · Bakersfield, CAS/N 22-1868N38090Santerre Gary R · Baileyville, MEBuilt 1941 · S/N 4-1543N38091Yanacek Steve J · Meadville, PABuilt 1941 · S/N 6776N38097Aarestad Potato Co Ltd · Halstad, MNBuilt 1941 · S/N 6785N3809MWood Robert A V · Anchorage, AKBuilt 1947 · S/N 12-2731N380CCHolmstrom Eric C · Las Vegas, NVBuilt 2001 · S/N 9934CCN380KPPeterson Timothy J · Watertown, SDBuilt 1947 · S/N 11-1586N38109Morris John · Oconomowoc, WIBuilt 1941 · S/N 6806N38118Mull Travis S · Vallonia, INBuilt 1941 · S/N 6813N38130Table Rock Aviation LLC · Lenoir, NCBuilt 1941 · S/N 5-882N38131Rivera Ar · Nevada City, CABuilt 1941 · S/N 5874N38139Armstrong David D · Mora, MNBuilt 1941 · S/N 5-883N3814PJasinski Jack J · Necedah, WIS/N 22-3504N38153Chapman Martin F · Bakersfield, CABuilt 1941 · S/N 41568N38160Cwynar Timothy A · Avon, OHBuilt 1947 · S/N 6828N3816MAnderson Jeremy J · Ankeny, IABuilt 1947 · S/N 12-2737N3816PJohnson Dale M · Seminole, TXBuilt 1955 · S/N 22-3506N3816ZBouchard Timothy D · Valdez, AKBuilt 1961 · S/N 18-7554N3817PCoslor Donald D Jr · Grand Island, NEBuilt 1955 · S/N 22-3507N3817ZLivermont Joann M · Dillingham, AKS/N 18-7555N38181Bayne Clyde O · Newcastle, WYS/N 4-1545N38184Yocum Daniel R · Boise, IDS/N 5-885N38185Langston Scott R · Foxhome, MNBuilt 1941 · S/N 4-1551N38187Stewart Thomas V · Churchville, NYBuilt 1941 · S/N 4-1552N38196Brown Travis E · Leicester, NCBuilt 1941 · S/N 4-1566N3819PLucas Lester L · Napa, CAS/N 22-3509N381CC182 Flight Corp · Bronx, NYBuilt 2001 · S/N 9936CCN3820ZBudd Kirkland G · Rushville, NES/N 18-7560N3821PRadach Kenneth D · Copper Center, AKBuilt 1955 · S/N 22-3511N38223Kuhn Brent · Bloomer, WIS/N 6869N38238Homolka James D · Ellsworth, KSBuilt 1941 · S/N 5-907N38239Flemming Richard E · Kinsman, OHBuilt 1941 · S/N 5-908N3823ZFranks Cory B · Idalou, TXBuilt 1960 · S/N 18-7563N38244Munroe Consulting Inc · Ocala, FLBuilt 1941 · S/N 5-915N38245Foster Gifford L · Torrington, WYBuilt 1941 · S/N 5916N3824MDraveling Larry J · Wasilla, AKFirst renewal noticeBuilt 1947 · S/N 12-2744N38251Bazil Nick G · Lehighton, PAS/N 5-923N38259Miles Andrew W · Colorado Springs, COBuilt 1941 · S/N 6894
Back to AD 99-01-05 R1