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.

N711HYTegeler Walter S · Westminster, MDBuilt 1999 · S/N 2025N711JJReady Aim Flyer LLC · New Castle, DEBuilt 1979 · S/N 1139-79N711KKRegistered aircraftBuilt 1969 · S/N 30-1870N711KNLowe Kevin · Martinsville, INBuilt 1999 · S/N 1004N711LPJohnson Tommy A · Grand Junction, COBuilt 1964 · S/N 2872N711NDFlight Leasing Corp · Wilmington, DEBuilt 2017 · S/N 2843881N711PKKramer Peter W · Copper Center, AKBuilt 2023 · S/N 176N711PTTaylor Stephen N · Punta Gorda, FLBuilt 1976 · S/N 0731N711QSaddlemire Joshua S · Lake Arrowhead, CABuilt 1975 · S/N RD1N711RNGoldsmith Donald E Jr · Brandywine, MDBuilt 1973 · S/N 17702010N711RVNicholson Kameran · Fowler, KSS/N 290N711SGGullo Santo · Ponce Inlet, FLBuilt 1966 · S/N 30-1300N711SHHighley Robert W Jr · Lakeland, FLBuilt 1984 · S/N 835N711TSStarr William E · Eagle River, AKBuilt 1976 · S/N 18-7609046N711UATuthill Andrew M · Etna, NHBuilt 1978 · S/N 17271695N711WBNewberg Edgar T · Hector, MNS/N B-1N711WEMelbourne Flight Training LLC · Melbourne, FLS/N 17272616N711XCFore Shannon Richard · Wasilla, AKBuilt 2016 · S/N CC19-0009N711YAStegmann Scott A · Port Orange, FLBuilt 1995 · S/N 235N711YCIturriria John M · Kuna, IDFirst renewal noticeBuilt 2005 · S/N 0023N711ZHappenstance LLC · Cabot, ARBuilt 1976 · S/N 177RG0959N712Oman Lee · Sequim, WAS/N 399N7120DWeiss James R · Westlake, OHBuilt 1957 · S/N 22-4980N7120GSky Hook Inc · Red Wing, MNBuilt 1969 · S/N 17258820N7120LTschirhart Larry S · San Antonio, TXBuilt 1974 · S/N AA5-0620N7120QClodfelter Terry Lynn · Norwood, NCBuilt 1972 · S/N 17260420N7120VOpulent Investments LLC · Mandan, NDBuilt 1974 · S/N 21-0043N7120YRoyal Ryan M · Lincoln, NEBuilt 1963 · S/N 30-139N7121DBohrman Robert C · New Berlin, WIBuilt 1957 · S/N 22-4981N7121PLecren Douglas · Wasilla, AKBuilt 1958 · S/N 18-7121N7121YUhlemeyer William A · Alvin, TXBuilt 1963 · S/N 30-140N7122AContinental Helicopters Inc · Sheffield, TXBuilt 1999 · S/N 2956N7122BCgu Aviation LLC · Naples, FLBuilt 1956 · S/N 22-4340N7122EChristiansen Aviation LLC · Wilmington, DEBuilt 2018 · S/N 4496447N7122GBirmingham Flight Center LLC · Birmingham, ALBuilt 1969 · S/N 17258822N7122KMacleod Gary G · Valentine, NES/N 18-335N7122RSimmons Heating And Air Conditioning LLC · Summerville, SCBuilt 1966 · S/N 28-21823N7122VProvance Brent L · Granbury, TXBuilt 1974 · S/N 22-0051N7122YSutton Jack M · Jesup, GABuilt 1963 · S/N 30-141N7123GJet & Rotor Aviation LLC · Sacramento, CABuilt 1969 · S/N 17258823N7123UMatherly Frank · Greenbrier, TNBuilt 1964 · S/N 2742N7123WHarvick Wayne P II · Kenmore, WABuilt 1962 · S/N 28-920N7124KBlackburn Douglas W · Auke Bay, AKBuilt 1950 · S/N 18-342N7124LTriad Management Group LLC · Papillion, NEBuilt 1974 · S/N AA5-0624N7124QVy Aviation LLC · Gentry, ARBuilt 1972 · S/N 17260424N7124RNewsome Thomas D · Canal Winchester, OHBuilt 1966 · S/N 28-21825N7124UGoss Brendan · Shady Shores, TXS/N 363N7124VHunter Cameron Brooks · Keller, TXBuilt 1974 · S/N 22-0053N7124WTuchols John E · Lockport, NYBuilt 1962 · S/N 28-921N7125GBohannan Joshua S · Rose Hill, KSFirst renewal noticeBuilt 1969 · S/N 17258825
Back to AD 90-04-06 R1