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.

N4870GCal Aggie Flying Farmers Inc · Davis, CABuilt 1979 · S/N 17273417N4870LWinyah Aviation LLC · Georgetown, SCBuilt 1967 · S/N 28-4225N4870PWooten Gerry W · Edmond, OKBuilt 1980 · S/N 15284834N4870UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842238N48710Conner Michael James · Scotts Valley, CABuilt 1977 · S/N 15280935N4871BMeise Fred Walter · Moses Lake, WAS/N 18-4967N4871CFalvey Paul J · Edgartown, MABuilt 1984 · S/N 28-8490101N4871ESloss John W · Sterling, AKS/N 7GC-76N4871VBt Aero Precission Flight Accademy LLC · Oakdale, CABuilt 1980 · S/N 172RG0406N48725Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280937N4872AIdaho Wool Growers Assn · Boise, IDFirst renewal noticeS/N 18-4969N4872DPs N4872d LLC · Green Bay, WIBuilt 1979 · S/N 17272381N4872LMartin Marvin J · Conrath, WIBuilt 1968 · S/N 28-4227N4873APapp Jacob R · Fort Edward, NYS/N 18-4971N4873FFirebrand Nation · Knoxville, TNS/N 28-7725034N4873G4873g Flying Club Inc · Punxsutawney, PABuilt 1979 · S/N 17273420N4873LBaker Justin · Titusville, FLBuilt 1967 · S/N 28-4229N4874Goin Jeff Trustee · Polk City, FLBuilt 1968 · S/N 025N4874BKoppelmann Kevin J · Cuba, MOS/N 15283687N4874TSmith Richard R Sr · Wellington, NVS/N 28R-7235128N48751Tyau Jon S · Las Vegas, NVBuilt 1977 · S/N 15280951N48753Harford Flying Club Inc · Kingsville, MDBuilt 1977 · S/N 15280952N48757Stone To Glass LLC · Lake Worth, FLBuilt 1977 · S/N 15280956N4875DNightwing Productions LLC · Aptos, CABuilt 1967 · S/N 670218N4875FVan Kirk Ronald · Wichita Falls, TXBuilt 1976 · S/N 28-7725033N4875ZRice Gary W · San Antonio, TXBuilt 1961 · S/N 22-8454N48762Carter Flygare Inc · Sacramento, CABuilt 1979 · S/N 15283369N48763Jet & Rotor Aviation LLC · Sacramento, CABuilt 1977 · S/N 15280959N48764Cohen Harold L · Pensacola, FLBuilt 1979 · S/N 15283370N48768General Aviation Support Corp · Rosamond, CAS/N 15283371N4876AMontgomery Daniel G · Wasilla, AKBuilt 1956 · S/N 18-4975N4876EFarrell Clifton S · Needville, TXBuilt 1959 · S/N 7GC-55N4876FCosta Air Service LLC · Painted Post, NYBuilt 1979 · S/N 17273094N4876GKing Bryan A · Austin, TXBuilt 1979 · S/N 17273423N4876TAyers Terry · Boise, IDBuilt 1972 · S/N 34-7250162N48779Bryan Robert G · Orland Park, ILBuilt 1977 · S/N 15280963N4877DAviator Air Flight School LLC · Grand Prairie, TXBuilt 1979 · S/N 17272383N4877JR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17273687N4877LTxp Designs LLC · Jasper, INS/N 28-4243N4878Medic Choppers LLC · Springdale, ARBuilt 1969 · S/N 029N48787Angel Aviation Inc · Peoria, AZBuilt 1977 · S/N 15280967N4878AMallek Edward J · Fairbanks, AKBuilt 1956 · S/N 18-4977N4878BSun Aircraft Management LLC · Ormond Beach, FLBuilt 1979 · S/N 15283689N4878LPeg Aviation LLC · Cedar Hill, TNBuilt 1967 · S/N 28-4244N4878TLorbiecki John E · Hubertus, WIS/N 28-7205214N4879DMorey Airplane Company Inc · Middleton, WIBuilt 1979 · S/N 17272384N4879EPappas William B · Dallas, TXBuilt 1959 · S/N 7GC56N4879TCombs Kenneth E · Canyon, TXBuilt 1972 · S/N 28-7225228N4879ZRobert P Brown Inc · Beatty, ORS/N 22-8460N487AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843750
Back to AD 90-04-06 R1