AD 90-04-06 R1

Registered aircraft · 68,377

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:90-04-06-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:90-04-06-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.

N5311ZWhitley Wes A · Dumas, TXBuilt 1961 · S/N 22-9014N5312HSkywarrior Flight Training Inc · Pensacola, FLBuilt 1975 · S/N 17265400N5312MMoore Aviation Inc · Beaver Falls, PABuilt 1980 · S/N 15284526N5312QHoogendorn Homer E · Wasilla, AKBuilt 1981 · S/N 15285098N5312SGace Flying Club · Ronkonkoma, NYBuilt 2002 · S/N 172S9285N53134Sundog Logistics LLC · Lenexa, KSBuilt 1981 · S/N 17274691N5313HRizzo Joseph A · Akron, NYBuilt 1949 · S/N 16-118N5313WWoodard Milton · Ripley, TNBuilt 1962 · S/N 28-367N5313ZMartinez Milton E · Fort Lauderdale, FLS/N 22-9017N53147Cloud Cappers Flying Club Inc · Salisbury, NCBuilt 1981 · S/N 17274693N5314E57d Flyers LLC · Shelby Township, MIBuilt 1978 · S/N 17271835N5314KLaporte Aviation Services Inc · La Porte, INBuilt 1980 · S/N 17274060N5314LGormley Laurie A · Las Cruces, NMS/N 28-4616N5314MAlpha Golf Aviation LLC · Naples, FLBuilt 1980 · S/N 15284528N5314PStaiger John L III · Saint Clair, MIBuilt 1958 · S/N 24-355N5314WRasler Christopher · Puyallup, WABuilt 1962 · S/N 28-369N53152Griffin Bruce H · Trenton, FLBuilt 1978 · S/N 177RG1352N53153Lopez Gabriel A Trustee · El Monte, CABuilt 1940 · S/N 75-731N53155Halley Ray Moor Jr · Hankamer, TXBuilt 1945 · S/N 75-520N53158Schoen William R · Madison, CTS/N 177RG1353N5315KAom Aircraft LLC · Wilmington, DES/N NAV-4-2215-BN5315LTorres Daniel A · Baldwin, NYBuilt 1968 · S/N 28-4617N5315ZGates Steven F · Rockford, ILS/N 22-9019N53160Benson Michael H · New Castle, PABuilt 1978 · S/N 177RG1354N5316HGade Dale A · Antioch, ILBuilt 1949 · S/N 16-121N5316PBrooks D Craig · Menifee, CABuilt 1958 · S/N 24-357N5316RTraining Planes LLC · Tampa, FLBuilt 1979 · S/N 172RG0053N5316WPenley Robert G · Corinth, TXBuilt 1958 · S/N 314N5316ZMarshall Jesse A · Moab, UTBuilt 1961 · S/N 229020N53175Kendall Investment Corp · Three Lakes, WIFirst renewal noticeS/N 177RG1357N5317DMonroe City Aviators LLC · Palmyra, MOBuilt 1979 · S/N 17272513N5317HHottel Cessna LLC · Prescott, AZBuilt 1975 · S/N 17265401N5317KN5317k Corp Trustee · Wilmington, DEBuilt 1980 · S/N 17274061N5317WUnterbach Mark J · Discovery Bay, CABuilt 1962 · S/N 28-373N5317ZBauman Michael P · Toronto, OHS/N 22-9021N53182Wardlaw James C · Albuquerque, NMBuilt 1981 · S/N 17274697N53187Salomon William · Woodstock, NYBuilt 1981 · S/N 17274699N53189Naylor Irvin H Jr · Charlotte, NCBuilt 2001 · S/N 2843434N5318EBishops Ltd · Virginia Beach, VABuilt 1978 · S/N 17271836N5318HZefting Brett M · Bellingham, WABuilt 1949 · S/N 16-123N5318LWing Timothy R · Raleigh, NCBuilt 1968 · S/N 28-4620N5318MHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 15284529N5318TSmith Stephan R · Morrisville, PABuilt 1972 · S/N 28-7225398N53194Jagav LLC · Lewes, DEBuilt 1978 · S/N 177RG1360N5319DCoachron Investments LLC · Grosse Ile, MIBuilt 1979 · S/N 17272514N5319PRockwell Collins Flight Services Inc · Cedar Rapids, IAS/N 15284912N5319SCampo Jonathan Ibarra · Lakeland, FLBuilt 1970 · S/N 28-26831N5319XMeadowlake Aviation LLC · Lenoir City, TNS/N 2842119N531BCEagle Fly Co · Hollywood, FLBuilt 1982 · S/N RUTLEDGE-0001N531BMJ&V Sky LLC · West Covina, CABuilt 1979 · S/N 28-7990510
Back to AD 90-04-06 R1