OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,369

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.

N12919Gibson Aviation Services LLC · Menomonie, WIBuilt 1973 · S/N 17262372N1291ASeale Sidney Joseph · Condon, ORBuilt 1951 · S/N 18-1094N1291CVand Flyve Klub · Newfolden, MNS/N 18-2502N1291FRegistered aircraftBuilt 1979 · S/N 17272986N12923Roberts Cody A · Lueders, TXBuilt 1973 · S/N 17262375N12926Norton Boe L · Carlsbad, NMBuilt 1973 · S/N 17262378N1292CTrout Island Transit LLC · Glen Ellyn, ILBuilt 1977 · S/N 17702696N1292JSoutheast Michigan Aircraft Sales Inc · Blissfield, MIBuilt 1975 · S/N 292N1292PEm Turbines Corp · Fort Lauderdale, FLS/N 23-327N1292UFlynn James M · Plain City, OHBuilt 1976 · S/N 17266986N1292XBurns Barry D · Amarillo, TXBuilt 1963 · S/N 165N12931Walden David C · Mesa, AZBuilt 1973 · S/N 17262382N12933Van Anda Aviation LLC · Apopka, FLBuilt 1973 · S/N 17262384N12935Ray Aviation LLC · Burkett, TXBuilt 1973 · S/N 17262386N12936Quinlan Patrick J · Cooper City, FLBuilt 1973 · S/N 17262387N1293FT-Craft Aero Club · Nampa, IDBuilt 1979 · S/N 17272987N1293TN1293t LLC · Wilmington, DES/N 34-7250283N12940Buffoon Flying Club · Mansfield, OHBuilt 1973 · S/N 17262388N12943Titsworth R G · Seekonk, MABuilt 1973 · S/N 17262415N12947Alltek Lebelle Ltd · Wilmington, DEBuilt 1973 · S/N 17262393N1294CJel Imaging Services LLC · Rochester, NYFirst renewal noticeBuilt 1977 · S/N 17702698N1294FClover Park Technical College · Lakewood, WABuilt 1979 · S/N 17272988N1294XMcglynn Brian · Friday Harbor, WABuilt 1963 · S/N 167N12951Huestis Peggy J · Havre, MTS/N 17262397N12952Wesselhoff Rick · Sedona, AZBuilt 1973 · S/N 17262398N12953Witmer Travis R · Odenton, MDBuilt 1973 · S/N 17262399N12955American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262400N1295AJenski Kobie · Sutton, AKBuilt 1951 · S/N 18-1098N1295TLutz Brian · Carmel, INBuilt 1972 · S/N 28-7205278N1295URegistration Pending · Monroe, WIRegistration pendingBuilt 1976 · S/N 17266989N1295XOz Aviation Inc · Cottonwood Falls, KSBuilt 1963 · S/N 168N12960Hennessee Timothy H · New Braunfels, TXBuilt 1973 · S/N 17262405N12968Rtd Aviation LLC · Hillsborough, NJBuilt 1973 · S/N 17262413N1296CLogan Tom B Trustee · Coeur D Alene, IDBuilt 1977 · S/N 17702699N1296UKirk Claire Y · Huntington Beach, CABuilt 1976 · S/N 17266990N1296XFox Judy · Ridgefield, WAS/N 169N12973Mor Aviation LLC · Gaithersburg, MDBuilt 1973 · S/N 17262418N12974Forest Ken W · Wales, NDBuilt 1972 · S/N 17262419N12976Wanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1973 · S/N 17262421N1297AOrwick Robert J · Newell, SDS/N 18-1101N1297FJprg Aviation Inc · Orlando, FLBuilt 1979 · S/N 17272990N1297JLemrich Aero Inc · Dallas, TXS/N 297N1297XScott Benjamin D · Grove City, OHS/N 170N12983Haman Aviation Services LLC · Nokomis, FLBuilt 1973 · S/N 17262427N12984Go Fly Az LLC · Gilbert, AZBuilt 1975 · S/N 17702394N12985Alamakee Flyers · Waukon, IABuilt 1973 · S/N 17262429N12991Usda Forest Service Fepp · Columbia, SCBuilt 1973 · S/N 17262432N12997Wausau Flying Service Inc · Wausau, WIS/N 17262437N1299AHunsicker Greg A · Berryton, KSBuilt 2000 · S/N 80252N1299URice Melvin G · Bridgeport, TXBuilt 1976 · S/N 17266993
Back to AD 90-04-06 R1