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.

N67XXLane Aviation Inc · Rosenberg, TXBuilt 2003 · S/N 9958CCN6800BHall John L · Port Angeles, WABuilt 1956 · S/N 22-4095N6800KHoech Terry H · Bothell, WABuilt 1949 · S/N 16-628N6802BHales Evan C · Haines, AKBuilt 1956 · S/N 22-4097N6803KDavis Rick L · Everett, WAS/N 16630N6803ZWagner Nathan D · Dane, WIBuilt 1963 · S/N 25-2452N6804BJanusz Stephen F · Westerville, OHBuilt 1956 · S/N 22-4099N6806BGalloway Michael C · Prim, ARBuilt 1956 · S/N 22-4101N6806KBourdon David · Green Cove Springs, FLBuilt 1949 · S/N 16-639N6807KLemire Darryl M · White Bear Lake, MNBuilt 1949 · S/N 16-636N6808BWroe Daniel C · Denton, MDBuilt 1956 · S/N 22-4102N6810ZAlbuquerque Soaring Club Inc · Albuquerque, NMBuilt 1963 · S/N 25-2471N6811Dinnerbell Farms LLC · Eden, WIBuilt 1957 · S/N 22-4783N6811KBashore Charles A · Madison, ALBuilt 1949 · S/N 16-646N6813LKing Robert B · Sheridan, WYBuilt 1974 · S/N 18-7409102N6814BMensing John P · Country Club Hills, ILBuilt 1956 · S/N 22-4109N6815BCopper River Airmotive LLC · Copper Center, AKBuilt 1956 · S/N 22-4111N6817BHarvey Benjamin A · Mountain View, CABuilt 1956 · S/N 22-4113N6817LClought John Finley III Trustee · Auke Bay, AKBuilt 1974 · S/N 18-7409101N6818KEckberg Robert K · Dakota City, IABuilt 1949 · S/N 16-650N6820BAnderas Per R · Green Bay, WIS/N 22-4116N6820LFoode Frank J · Cordova, AKBuilt 1974 · S/N 18-7409104N6822KGoad Graham · Mcminnville, ORBuilt 1949 · S/N 16-653N6822LDavis Robert E · Wasilla, AKBuilt 1974 · S/N 18-7409105N6825BAlborn Wyatt A · Homer, AKBuilt 1956 · S/N 22-4121N68287Lockwood Albert G · Eden, IDS/N 5-1475N6828BVantreese Jason B · Quanah, TXS/N 22-4125N6829LEntropic Synergies LLC · Visalia, CAS/N 25-4960N682DCSteele Aviation Inc · Walnut Cove, NCBuilt 1961 · S/N 22-8660N6831KAbbott Cedric M · Buckfield, MEBuilt 1949 · S/N 16-667N6833BBlatchford Devin M · Arkansas City, KSBuilt 1956 · S/N 22-4131N6834KKilbourned Garrot · Liberal, KSS/N 16-669N6835KWill Robert I Jr · Shoreline, WAS/N 16-670N6836BHowes Christopher T · Allardt, TNBuilt 1956 · S/N 22-4134N6836KBundrant Wlliam D · Snellville, GABuilt 1949 · S/N 16-671N6837KHagglund Carl D · Pendleton, ORS/N 16-672N6838BMize Donnie Glenn · Pearland, TXBuilt 1956 · S/N 22-4136N6840KValley Airways Inc · Scottsbluff, NEBuilt 1949 · S/N 16-675N6844KNoguess Levi B · Belton, TXBuilt 1949 · S/N 16-678N6844ZAntelope Valley Soaring Club · Llano, CABuilt 1963 · S/N 25-2516N6845BShrode Rafe C · Jewett, TXS/N 22-4144N6845KGottfried Virgil P · Wilkesboro, NCBuilt 1949 · S/N 16-679N6845ZBr Trucking LLC · Cut Bank, MTBuilt 1964 · S/N 18-8132N6847BOtt Grosvenor LLC · Dillingham, AKBuilt 1956 · S/N 22-4146N6847KWilson Galen B · Belchertown, MAS/N 16-681N6848BPainter William L · Salem, VAS/N 22-4147N68490Chersky Brian · Santa Maria, CABuilt 1943 · S/N 5-1456N6849BWeeks Vaughan B · Racine, WIS/N 22-4148N6850ZWagner Construction Inc · Intl Falls, MNBuilt 1964 · S/N 18-8133N6852BTaylor David L · Mexico, MOBuilt 1956 · S/N 22-4151
Back to AD 99-01-05 R1