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.

N612JLHeartland Aviation Inc · Alliance, NES/N 18-7409151N612KSRv Co LLC · Boulder, COBuilt 2010 · S/N 001N612LCGoodman Lawrence A · Granbury, TXBuilt 1969 · S/N 28-26033N612PAJenkins Phillip R Jr · Fuquay Varina, NCBuilt 1977 · S/N 28-7790518N612RANorton Gregory Victor · Petersburg, ILBuilt 2012 · S/N 73479N612RTWolding Mylo D · New Town, NDBuilt 2017 · S/N 82822N612TMMcdermott James Timothy · Newell, SDBuilt 2012 · S/N 1001N612WTPlane Leasing LLC · Tempe, AZBuilt 1978 · S/N 28-7816655N6130DJones Matthew A · Saluda, NCBuilt 1979 · S/N 17272610N6130JUtley Gary D · Okmulgee, OKFirst renewal noticeBuilt 1976 · S/N 28-7615307N6130MKing Mike · Webster, TXFirst renewal noticeBuilt 1980 · S/N 15284627N6131JDotson Tem · Hindsville, ARBuilt 1976 · S/N 28-7615308N6131SClassic Rotors Museum · Ramona, CABuilt 1965 · S/N 18-38N6132GMorcom Aviation Services Inc · Everett, WABuilt 1979 · S/N 17273570N6132JWolf Aviation Network Inc · Westfield, MABuilt 1976 · S/N 28-7615309N6132LSale Reported · Charles Town, WVSale reportedBuilt 1970 · S/N AA1-0332N6132VDorsey Russell R · Phoenix, AZBuilt 1980 · S/N 172RG0584N61330Holman Ricardo Earl · Creswell, ORBuilt 1989 · S/N 11065CN6133AReinders Monte M · Port Townsend, WABuilt 1990 · S/N 14001CN6133DThomas Aviation · Granada Hills, CABuilt 1979 · S/N 17272611N6133HCbc Aviation LLC · Hayden, IDBuilt 1979 · S/N 1085-79N6133JArbello Danny · Sterling, VAS/N 28-7615310N6133LBarnett George W · Salem, INBuilt 1970 · S/N AA1-0333N6133NSiesta Key LLC · Wilmington, DES/N M-1216N6134GMagruder David · Independence, LABuilt 1979 · S/N 17273571N6134LEuro 2000 Inc · Merritt Island, FLS/N 15284362N6134NChris Bellinger Dvm LLC · Newalla, OKS/N MA-345N6134SPatten Jeffery D · Rapid City, SDBuilt 1965 · S/N 18-41N6134WRegistration Pending · Mesa, AZRegistration pendingBuilt 1964 · S/N 28-20151N6135DHowe Bryan · Edgewater, FLBuilt 1956 · S/N 22-4779N6135QLake Effect Aviation LLC · Java Center, NYBuilt 1981 · S/N 15285159N6135WWhiskey Aviation LLC · Huntsville, ALBuilt 1964 · S/N 28-20152N6136JTennessee Flight Academy LLC · Bristol, TNBuilt 1976 · S/N 28R-7635301N6136KAll On Black LLC · Mount Nebo, WVBuilt 1994 · S/N S1672N6136LTheriot Conchita F · Anderson, SCBuilt 1970 · S/N AA1-0336N6137DPhelps Joe · Princeton, KYBuilt 1957 · S/N 22-4781N6137EPennington Mitchell T · Medley, WVBuilt 1978 · S/N 17271994N6137SPiasecki Aircraft Corp · Coatesville, PABuilt 1965 · S/N 18-45N6137WPrepmasters Inc · Boynton Beach, FLS/N 28-20134N6138VGlover Michael M · Mechanicsville, VABuilt 1968 · S/N 28-23988N6139LGdg LLC · Lewes, DEBuilt 1970 · S/N AA1-0339N6139MKelly David M · Issaquah, WAFirst renewal noticeBuilt 1980 · S/N 15284630N6139WFleetwood James D · French Lick, INBuilt 1964 · S/N 28-20157N613ADhs Operations LLC · Wilmington, DEBuilt 1997 · S/N 17280248N613ACBas Part Sales LLC · Greeley, COBuilt 2014 · S/N 2843757N613AMW & A Flight LLC · Greenville, SCBuilt 2004 · S/N 20-1038N613APThomas Lucas G · Beebe, ARBuilt 1976 · S/N 190-76N613BKMaxwell Roy J · Kenai, AKBuilt 1948 · S/N 1084795N613EHart David E · Bartlett, TNBuilt 1984 · S/N CRC-3N613FPlane Fun Inc Tr Trustee · Snellville, GABuilt 1970 · S/N 39-45
Back to AD 90-04-06 R1