OpenAirDocs.org
AD 2005-18-20

Registered aircraft · 19,277

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:2005-18-20')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-18-20')
  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.

N10007Insko Matthew T · Papillion, NEBuilt 1966 · S/N 21058839N1000LWise Joe · Kilgore, TXBuilt 1966 · S/N TC-1000N1003AOakshire Aviation LLC · Yakima, WABuilt 1978 · S/N P21000078N1004PVankirk Malcolm R · Frederick, MDBuilt 1954 · S/N 23-6N1007F007 Aviation LLC · Wilmington, DEBuilt 1968 · S/N TC-1163N1007XD&R LLC · Emory, TXS/N 34-7570182N1008AAerial Surveys International LLC · Watkins, COBuilt 1967 · S/N 402-0097N1008NK W Racing LLC · Angola, INBuilt 1973 · S/N 27-7305152N100AJN8006j LLC · Shiloh, ILBuilt 1972 · S/N 421B0322N100BABemidji Aviation Services Inc · Bemidji, MNBuilt 1968 · S/N U12N100BRIsr Aviation LLC · Wilmington, DEBuilt 1981 · S/N LA-116N100BSC & C Logging LLC · Kelso, WABuilt 1966 · S/N 27-3431N100BYFirst Flight Aviation LLC · Boerne, TXBuilt 1984 · S/N 1565 S.A.N100BZHartwell Holdings LLC · Dover, DEBuilt 1984 · S/N FA-32N100CCSeneca Tank · Des Moines, IABuilt 1982 · S/N 425-0170N100CFRed Rooster Rentals LLC · Alto, GABuilt 1972 · S/N 229N100CNAileron Aviation Inc · Sparta, TNS/N 27-7754050N100CXCs Leasing LLC · Rockville, MDBuilt 1980 · S/N 414A0623N100DBState Of Wisconsin · Madison, WIBuilt 1980 · S/N 21063970N100EMKentem100 LLC · Asheboro, NCBuilt 1981 · S/N 31-8152196N100FMRivkin Gerald · Saint Augustine, FLBuilt 1969 · S/N TE-729N100GKLewis David B · Saint Louis, MOBuilt 1973 · S/N 210-59905N100GMHuguenard Jefferson J · Alpharetta, GABuilt 1968 · S/N TC-1183N100GSPegasus Florida I Inc · San Diego, CABuilt 1974 · S/N P-301N100HJClipper Air Inc · Tomball, TXBuilt 1974 · S/N 340-0334N100HMSchultz David J · Neenah, WIBuilt 1978 · S/N 340A-0559N100HSAir Works Ltd · Wilmington, DES/N E-3506N100JDMark Aviation LLC · Kingsport, TNBuilt 1981 · S/N 414A0669N100JLBytelogics Inc · New York, NYS/N 421-0008N100JPAviation Consulting LLC · Ada, MIS/N TH-1683N100KBExecutive Air Taxi Corp · Bismarck, NDBuilt 1979 · S/N LJ-820N100KEPm Leasing Inc · Perris, CABuilt 1974 · S/N 313SAN100LKKoebele Thomas R · Cape May, NJBuilt 1977 · S/N CE-686N100LLPremiere Brand Meats · Shasta Lake, CABuilt 1973 · S/N 414-0429N100LSAg Flyers Inc · Torrington, WYBuilt 1969 · S/N P-116N100LYLyon Aviation Inc · Pittsfield, MAS/N 31-8052064N100MDHoppe Joel A · Mankato, MNBuilt 1978 · S/N 340A0535N100MLMl Aviation LLC · Boulder, COBuilt 1972 · S/N TH-249N100MRCarlson Carl J II · Aledo, TXBuilt 1973 · S/N TC-1512N100MTDevo Leasing LLC · Park City, UTBuilt 1979 · S/N 340A0957N100MUWakaya Services Inc · Dover, DEBuilt 1980 · S/N 793SAN100NKLand Air Sea Inc · Chesapeake, VABuilt 1969 · S/N TE-767N100POut Island Magic LLC · Gainesville, FLBuilt 1982 · S/N 31-8252019N100PETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 680-0580N100PSG & C Property Hc LLC · San Francisco, CABuilt 1987 · S/N CE1140N100PYTbm Flying Lc · Pampa, TXBuilt 1981 · S/N BB-890N100PZAeromotors LLC · St James, MOBuilt 1974 · S/N TH-554N100QTSouthwest Aviation Inc · Marshall, MNBuilt 1976 · S/N LJ689N100RABonanza Holdings Group LLC · Greenville, NCBuilt 1977 · S/N P405N100RBIngraham Donald S · New Bern, NCBuilt 1991 · S/N CE-1586
Back to AD 2005-18-20