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.

N7834GSmith Perry L · Brook Park, MNS/N 17259534N7834HWilde Air Service-Huron LLC · Volga, SDBuilt 1946 · S/N 12-734N7834NVector Aviation LLC · Mentor, OHBuilt 1969 · S/N 28-5288N7834VMorris Tommy R · Houston, TXBuilt 1964 · S/N 2870N7834WCleek Norris E · Orland, CABuilt 1964 · S/N 28-1851N7834YBall Half Out LLC · Mesa, AZBuilt 1965 · S/N 30-911N78351Caron John · Ellsworth, MIBuilt 1968 · S/N 17257579N78354Tonar Richard J Jr · Omaha, NES/N 17257581N78355Fleming Gary R · Wickliffe, KYBuilt 1968 · S/N 17257582N78358All American Aviation LLC · Fort Worth, TXS/N 17257585N78359Burns Stanley R · Flagler, COBuilt 1968 · S/N 17257586N7835NOrrill Bill · Godfrey, ILBuilt 1969 · S/N 28-5289N7835YRegistration Pending · Lewes, DERegistration pendingBuilt 1965 · S/N 30-912N78367Dardis Barry J · Great Falls, MTBuilt 1968 · S/N 17257587N7836NMelancon Scottie J · Baton Rouge, LABuilt 1969 · S/N 28-5291N7836SWilbur-Ellis Co · Salinas, CABuilt 1967 · S/N 7860N78371Lillace Kevan · Shelby, MTBuilt 1968 · S/N 17257590N78375Bozeman Leasing Inc · Bozeman, MTS/N 17257593N7837GGlass Jay Thomas · El Dorado, ARBuilt 1970 · S/N 17259537N7837HCounsell Michael J · Moses Lake, WABuilt 1946 · S/N 12-737N7837MDiamond B Farm Inc · Gamaliel, KYBuilt 1962 · S/N 2373N7837WHock Matthew G · Culbertson, NEBuilt 1964 · S/N 28-1854N78385Amf Aviation LLC · Dallas, GABuilt 1968 · S/N 17257595N78388Fortner Weston · Fort Payne, ALBuilt 1968 · S/N 17257596N7838NWright David P Jr · Chandler, AZBuilt 1969 · S/N 28-5293N78395Fgds LLC · Louisville, KYBuilt 1968 · S/N 17257599N7839DMartin David · Jackson, GABuilt 1957 · S/N 22-5489N7839GGerty Air LLC · Sidney, MEBuilt 1970 · S/N 17259539N7839NHaddle Eddie J · Lindon, UTBuilt 1969 · S/N 28-5295N7839VHafter Mark S · Cincinnati, OHBuilt 1965 · S/N 461N783AJApple Ronald L · Fort Myers, FLBuilt 1979 · S/N AA5B1093N783BWestside Air Inc Renton · Renton, WABuilt 1958 · S/N TD-55N783DGJeffery & Weiss Holdings LLC · Long Beach, CABuilt 1980 · S/N 17274063N783FMFmfa Inc · Wilmington, DEBuilt 1980 · S/N 17274259N783GSSchulenberg Gilbert H · Buffalo, NYBuilt 2008 · S/N 70931N783LAN783la LLC · Philadelphia, PABuilt 2025 · S/N 28020215N783LKPullis Troy K · Hutchinson, MNBuilt 1959 · S/N 22-6900N783LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2015 · S/N 4496381N783MSKornacki Daniel · Fayetteville, GABuilt 2000 · S/N 80783N783NDVertol Systems Company Inc · Destin, FLBuilt 2016 · S/N 4496398N783RVAvexp1 LLC · Fayetteville, GABuilt 2013 · S/N 74002N783SHKmc Aircraft Leasing LLC · Spanish Fork, UTBuilt 2004 · S/N 3617N78408On The Fly Aero LLC · Ocean City, NJBuilt 1968 · S/N 17257604N7840DDavis Steven T · Colleyville, TXBuilt 1957 · S/N 22-5490N7840FLederach David B · Bethlehem, PABuilt 1976 · S/N 28-7790228N7840NBiby Steven R · Churchs Ferry, NDBuilt 1969 · S/N 28-5294N7840VShedd John G · Hopewell, NJBuilt 1965 · S/N 462N7840WTomic Milos · Westminster, COBuilt 1964 · S/N 28-1857N7840XShaw Christopher S · Porterville, CAFirst renewal noticeBuilt 1961 · S/N 48340N7840YArno Philip A · Clarence Center, NYBuilt 1965 · S/N 30-920
Back to AD 90-04-06 R1