AD 2000-01-16

Registered aircraft · 2,711

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

N20MWStriebel David J · Dayton, OHBuilt 1975 · S/N 421B0918N20WAOn Air Company LLC · Sewickley, PAS/N 414A0280N210FCBaked Industries Inc · Yuba City, CABuilt 1975 · S/N 421B0908N211SVMatthews Aviation LLC · Greensboro, NCS/N 340A1000N21234Positive Rate LLC · Kenosha, WIBuilt 1982 · S/N 340A1207N212RVMinuteman 12 LLC · Wilmington, DES/N 421C0684N213MRogers Ronald J · Crystal Lake, ILBuilt 1978 · S/N 310R1335N214CCSteele Aviation LLC · Tuscaloosa, ALS/N 421C0670N214DFGaylord Hangars LLC · Gaylord, MIBuilt 1973 · S/N 421B0461N215CBKw Bradley Associates LLC · Manlius, NYBuilt 1980 · S/N 340A1019N215MPPersson Timothy J · Kansas City, KSS/N 421C1231N216LBBail Air LLC · Port Saint Lucie, FLBuilt 1974 · S/N 414-0545N218CFLevel 200 LLC · Charlottesville, VABuilt 1980 · S/N 340A0989N21GFBas Part Sales LLC · Greeley, COBuilt 1971 · S/N 421B-0209N21KDMrd Aviation LLC · Windsor, COBuilt 1979 · S/N 414A0439N21MTTarrant County College · Fort Worth, TXBuilt 1967 · S/N 320F-0017N21SGTwo One Sierra Golf LLC · Seattle, WABuilt 1976 · S/N 421C0039N21SSMidwest Corporate Air Inc · Bellefontaine, OHBuilt 1978 · S/N 421C0473N21WUDallas Aero & Sales LLC · Poplar, MTBuilt 1979 · S/N 421C0650N220GDJoseph M De Lecce Trustee · Prather, CAS/N 414A0459N220XPOleary Patrick G · Lake Tapps, WAS/N T310Q01020N2211QHill Jeffrey A · Bridgeport, WVBuilt 1968 · S/N 421A0011N2214Q421 Partners · Delphi, INBuilt 1968 · S/N 421A0014N2221QAviation Sales And Charter LLC · Dover, DEBuilt 1968 · S/N 421A0021N222AXGraven Timothy G · Foristell, MOBuilt 1970 · S/N 414-0078N222BJFlight Smith LLC · Orem, UTBuilt 1972 · S/N 414-0264N222FGSkytravel LLC · Victoria, TXBuilt 1981 · S/N 414A0823N222LTwo Motor Odor LLC · Paris, TXS/N 320E-0053N222MDElx Aviation LLC · Hartford, MIBuilt 1974 · S/N 310Q1013N222PLAnderas Per R · Green Bay, WIS/N 414A0521N222PRFlying South LLC · Wilmington, DEBuilt 1973 · S/N 4140384N222RDAviation Consultants Inc · San Luis Obispo, CABuilt 1977 · S/N 340A-0366N222RMKelco LLC · Helena, MTBuilt 1971 · S/N 414-0168N222STEau Claire Aviation LLC · Eau Claire, WIBuilt 1976 · S/N 310R0679N222SVEllsworth Jason W · Hamilton, MTS/N 414-0164N2235QSparx Logistics USA Ltd · Charlotte, NCBuilt 1968 · S/N 421A0035N2236QWoods Leland W · Klamath Falls, ORBuilt 1968 · S/N 421A0036N223PBHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0105N226HPRegistration Pending · Valdosta, GARegistration pendingBuilt 1978 · S/N 414A0084N228JHBuzzed Landing LLC · Ocean Springs, MSBuilt 1980 · S/N 421C-1006N2293FTwo Mile High Mining LLC · Victor, COBuilt 1970 · S/N 414-0097N22AMJays Aircraft Maintenance Inc · Costa Mesa, CABuilt 1979 · S/N 310R1634N22GBHolland Kenneth F Trustee · Santa Clarita, CABuilt 1977 · S/N 310R1237N22NRJefferson Aviation LLC · Seville, OHBuilt 1974 · S/N 4140497N22PTGuy Transportation Ltd · Wilmington, DEBuilt 1963 · S/N 320B0039N230MWGot Wings LLC · Woodbury, NYS/N 421C0671N231JPQuest Air Inc · Cocoa, FLBuilt 1975 · S/N 414-0628N232ASGuggenair LLC · Carbondale, COBuilt 1978 · S/N 310R1369N232DTChancellor Shares LLC · Liberal, KSBuilt 1979 · S/N 414A0232N233JHAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1977 · S/N 414A0009
Back to AD 2000-01-16